All's well that ends well. Email arrived today.

Thanks.

Mark.

😛

If you were moving from prediominantly 2000 to 200(5 or 8) I would jump to 2008 and have the three years extra of support for the product. If you are...

to turn the puzzle upsie down.

Would you find it acceptable to have a time dimension where you drop down the member MAT or do yuo want to base your MAT...

Ok,

thanks I now think I know what you want to do - Jopin Projrecttask to Projecttask to expose the data per row in the project task table.

You are trying to...

If you remove the project task dimension it should work as that join seems to be ok. What are you trying to get out of the prject task dimension?

Ells

:w00t:

its in the joins.

From the abopve your fact table links to the projecttask table that links to the HR table.

My guess is there is something wrong with the fact table...

Have you put the image in the public folder of your sky drive. This is at the top level of sky drive. The link for one of my docs looks...

I could not see the image.

Errors of this kind are normally found when you fact table has a value for a dimension that is not stored in the dimension...

As Steve said. Gemini is an add in for Excel. These two together will allow you to play with Gemini.

Is 2008R2 required orr can I use Gemini to look at...

this is not going to cure the problem but in BIDS in the solution explorer you will see the solution and directly underneath that is the AS database. Rich click...

Maybe consider what you want to see as the end result. Create a test cube with just two version of week and see what you think and what the send...

If it was down to me and not drive by some real business need I would go for

week numbers:

Create a unique id for the week. This id will be something...

would you like to explain why there are

weekdesc1,

weekdesc2,

....

weekdesc7

and the different year columns as this may help me understand what you want from this dimension?

I think a single row from...

Many thanks Steve. I have gone down the same path and I think I am just waiting on the Email. I Email Microsoft and the response back assumed I had...

yep. Put breakpoints in

Ells.