September 2, 2009 at 2:23 am
Hello, everyone. I am new to SSAS and MDX world. I have figured out a calculated measure like this:
aggregate([PERIOD].[MONTH].CurrentMember.Lag(11) : [PERIOD].[MONTH].CurrentMember, [Measures].[SALES])
I have created it from visual studio cube designer, calculations tab.
This is a MAT calculation, which calculates the sum of the previous 12 months from the current month. But this only works for SALES measure. I have some others measure like CU, UN and I want the same MAT calculation for these measures also.
Can anyone help me how I can change this calculated member to work for all the measures. I know that I can create separate calculated measures for the other measures. But I want to know whether its possible to create one calculated member to work for all the measures (just as the formula works for all the periods).
Thanks in advance.
September 2, 2009 at 8:09 am
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 on any month not just the current month? Would one user want to see MAT for July 2009 and another the MAT for September 2009?
Ells.
😎
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply