Calculated Members - Crossjoin? |
|
I am adding a calculated member to a cube where I want to aggregate differences between measures from a number of last periods against a measure for the current period:
Simplified I am using this:
SCOPE ([Measures].[Fact3]);
THIS =
Aggregate( LastPeriods(3,[Period].CurrentMember),
([Measures].[Fact1]-([Period].CurrentMember,[Measures].[Fact2]))
);
END SCOPE;
But this returns:
(Period1 Fact1 - Period1 Fact2) + (Period2 Fact1 - Period2 Fact2) + (Period3 Fact1 - Period3 Fact2)
But I want:
(Period1 Fact1 - Period3 Fact2) + (Period2 Fact1 - Period3 Fact2) + (Period3 Fact1 - Period3 Fact2)
Any help appreciated.
Thanks
|
Re: Calculated Members - Crossjoin? |
|