Skip to Content
0
Former Member
Apr 15, 2014 at 05:01 PM

Issue while referring to a particular Cross Section value across various dimensions

33 Views

Hi All

We are trying a logic script where we want to pull average salary data from a particular cross section

The dimensions and their corresponding members to be referred are:

P_PROJECT NO_PROJECT

P_CUSTOMER No_Customer

P_ANALYSIS NO_ANALYSIS

SALES_TERRITORY1 NO_SALES_TER

The following code works where I am not using a cross section for the above dimensions:

*WHEN ACCOUNT

*IS "MET-COS.1.1"

*REC(EXPRESSION = ((%VALUE%)*([ACCOUNT].[MET-SAL.3.1])),ACCOUNT = "FN-COS.1.2")

*ENDWHEN

whereas as soon as I try to reference the particular cross section (coded below), the validation fails throwing an error

*WHEN ACCOUNT

*IS "MET-COS.1.1"

*REC(EXPRESSION = ((%VALUE%)*([ACCOUNT].[MET-SAL.3.1],[P_PROJECT].[NO_PROJECT],[P_CUSTOMER].[No_Customer],[P_DEPARTMENT].[ED_Input],[P_ENTITY].[PUN_C],[SALES_TERRITORY1].[NO_SALES_TER],[P_ANALYSIS].[NO_ANALYSIS])),ACCOUNT = "FN-COS.1.2")

*ENDWHEN

Error: Unknown Dimension Name in the keyword (Screenshot below)

What am I missing here?

Any insights are deeply appreciated.

Thanks

AJ

Attachments

Error.png (25.9 kB)