I'm having some trouble trying to get a figure for previous year when using a semi additive measure (LastChild).
For a measure that uses Sum the process would normally be:
SUM(PARALLELPERIOD([Time].[Fiscal].[Fiscal Year], -1, [Time].[Fiscal].CURRENTMEMBER), [Measures].[Whatever] )
But obviously if I do a sum against a semi-additive measure it gives me a massive amount.
To give a little background the data that is in the source table is already a summed amount so the table is:
Date Category Amount
01/04/2010 Blah 3654
Is there any way I can achieve an equivalent of the above MDX using a LastChild member? The only other thing I can think of doing is to split the source so that (for the above) 01/04/2010 in the blah category would have 3654 rows and then do a sum of that
Many thanks in advance :-)
View Complete Post