Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Member formula over 2 dimensions

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!

Not what you were looking for? View more on this topic or Ask a question