Skip to Content
0
Former Member
Apr 13, 2010 at 09:49 AM

Member formula over 2 dimensions

139 Views

Hi,

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?

Thanks!