on 12-04-2010 8:22 AM
Hi experts!
I have C_ACCOUNT dimension with 0001,0002,... members and when I try to use this script:
*XDIM_MEMBERSET TIME=2005.Q4
*XDIM_MEMBERSET ENTITY=<ALL>
*XDIM_MEMBERSET INTCO=I_NONE
...
*SELECTCASE 0001
*CASE >100
0002=0001
*ENDSELECT
*COMMIT
I have got this error message: Invalid MDX command...the same situation when I try to use IIF:
0002=IIF(0001>100,0001,NULL)
what's wrong in my code? thanks in advance!
Problem has been resolved by using SAP Note 1361851 - BPC7NWSP06: Collective Note for Script
Logic
The correct syntax is
*COMMIT
...
[C_ACCT].[#0002]=IIF([C_ACCT].[0001]>100,[C_ACCT].[0001],NULL)
...
*COMMIT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.