Member formula over 2 dimensions
I want to create member formulas involving two dimensions: account and time.
As a first simple example, I want to take one case from sap note 0001356081:
Extsales compared to Extsales last year:
So, I created a new member "MyKPI" in the Account Dimension and define the following dimension formula for it (copy pasted from sap note):
(([ExtSales]/([ExtSales],PARALLELPERIOD([TIME].[LEVEL00],[TIME].[CURRENTMEMBER])) - 1) * 100
If I try to process the dimension, I am getting the follwing error message:
Members invalid on Dimension (Time.Currentmember)...
Looks like it doesn't like the Currentmember (this is needed to get the current member dynamically!).
Has anybody implemented sth similar and can help?