Viewing 15 posts - 1 through 15 (of 26 total)
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...
November 27, 2007 at 12:13 am
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...
October 5, 2007 at 12:08 am
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...
October 27, 2006 at 3:22 am
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...
September 23, 2006 at 4:51 am
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...
September 19, 2006 at 11:39 am
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...
September 18, 2006 at 11:05 pm
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...
August 30, 2006 at 1:19 am
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....
August 25, 2006 at 11:46 pm
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...
February 21, 2006 at 11:54 pm
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...
February 9, 2006 at 3:21 am
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:
0 - 15 Days
15 - 30...
February 9, 2006 at 3:12 am
Thanks for the help - I'll give it a try tonight.
January 18, 2006 at 7:57 am
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...
December 12, 2005 at 11:53 pm
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...
December 6, 2005 at 12:29 am
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...
November 24, 2005 at 11:25 pm