Hi Jeff

You raise a point that goes beyond just posting on forums - In the general office situation this is also common: People ask questions without being clear and actually...

Imagine doing the task with the wrong / outdated tools and base your estimate on that. e.g How long would it take to build the fort using only a hand...

I think people list every single thing they have ever touched on their CVs just to get a reasonable key word hit rate. Recruiters then find a few key words and...

It can get a bit ridiculous - my company restricts 'Restaurants and entertainment' so I can't pick up a fast food menu when I feel like something other than canteen...

If your compay is paying, then the course is the quickest and most effective way to get going. I was thinking more from the point of view that you might...

Hi Bart

If you are a beginner, then Hands on is probably the best way to get started. The down side is that you can't cover much detail in a hands...

Got to respectfully disagree here. Imagine we didn't correct the idea that the earth was the centre of the universe, that the earth is flat, that the theory of relativity...

You can also try Applied Microsoft Analysis Service 2005 (And Microsoft Business Intelligence Platform) by Teo Lachev. Its quite good and takes you through building solutions on the AdventrueWorks sample database....

You could do a calculated measure that divides e.g. Sales Price by units to get an average sales price. Something like:

[Measures].[Store Sales]/[Measures].[Sales Count]

Not sure what you are averaging but...

Hi Jeff

Are you joining the fact table to the time dimesnion with a key or are you using dates in the fact table?

Maybe the time dimension is reading the...

I haven't worked with accounting much but maybe something like this could work:

Make type of time dimension with a hierarchy something like this:

All Time

    0 - 15 Days

    15 - 30...

Thanks for the help - I'll give it a try tonight.

I haven't tried this myself but there is a .hierarchy function and I would imagine you could use it to test in which hierarchy of time the current member is...

Hi there

In the most simplistic terms, if you have a measure of actual and one for budget, you could do a calculated measure simply as ([measures].[budget] - [measures].[actual])

In Analysis services...

Have you tried IIf statements

e.g. IIF([measures].[mymeasure]> 10000, IIF([measures].[mymeasure]) <50000, [measures].[mymeasure], Null), Null) - i.e. if the value is between 10 and 50 thousand return it otherwise return null

I'm also a bit...