cancel
Showing results for 
Search instead for 
Did you mean: 

BPC NW MDX - IIF/SELECTCASE doesn't work

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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