January 14, 2010 at 3:47 am
Hi,
I have simple problem.
Ive got running cube with:
Dimensions: Item, Time
Mesure: Quantity
Current cube shows me sum of items for current time (date, year...)
What I need to help with:
How co modify this measure that it will show me all quantity till choosen time from time dimension.
For example:
2008 2009
Item1 300 310
Item2 310 315
Item3 200 200
So In year 2009 quantity reached of 10 Item1, 5 Item2 and 0 Item3.
Thank you for any help!
January 14, 2010 at 5:19 am
I made step forward and created following MDX script:
SUM ( { [Time].[Year Name].&[Calendar 2002]
, [Time].[Year Name].CurrentMember }
, [Measures].[Quantity]
)
But it gave me only SUM between 2002 and CurrentMember, I need to change &[Calendar 2002] with something like previous [Year] or [Month] or [Day ]
Any advice?
January 14, 2010 at 6:15 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic847433-17-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply