on 06-03-2011 4:32 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.