cancel
Showing results for 
Search instead for 
Did you mean: 

Logic: unknown dimension name

Former Member
0 Kudos

Hi,

I am trying to get a script to work.

*XDIM_MEMBERSET OWNACCOUNT=METHOD,PCON,PMIN,PGROUP

*XDIM_MEMBERSET CONSOLVIEW=%GROUPS%

*WHEN OWNACCOUNT

*IS "METHOD"

*WHEN ([OWNACCOUNT].[METHOD])

*IS "90"

*REC(EXPRESSION=(1-([OWNACCOUNT].[PCON]),OWNACCOUNT="PMIN")

*ELSE

*REC(EXPRESSION=0,OWNACCOUNT="PMIN")

*ENDWHEN

On validating this script I get an error message:

Unknown Dimension Name in Keyword: "([OWNACCOUNT]:

Essentially what I need to achieve is:

If a user enters a value of 90 on the member METHOD in the dimension OWNACCOUNT, I want the system to also put of value of (1 - the value of the member PCON in the dimension OWNACCOUNT) onto the member PMIN in the dimension OWNACCOUNT.

My problem is that I do not understand what the error message means.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Arnold,

Is the Method is the Property of "OWNACCOUNT"? If yes, check the logic given below.

//*XDIM_MEMBERSET OWNACCOUNT=METHOD,PCON,PMIN,PGROUP

//*XDIM_MEMBERSET CONSOLVIEW=%GROUPS%

*WHEN OWNACCOUNT.METHOD

*IS "90"

*REC(EXPRESSION=(1-[OWNACCOUNT].[PCON],OWNACCOUNT="PMIN")

*ELSE

*REC(EXPRESSION=0,OWNACCOUNT="PMIN")

*ENDWHEN

Thanks

Former Member
0 Kudos

Hi,

OWNACCOUNT is the (account) dimension and METHOD is a member of that dimension. User would enter a value on that account such as 90, 86 or similar and I need the script to perform a calculation based on the value a user has entered.