BPC 10.1 NW Issue with WHEN/IS not recognizing DIMENSION.PROPERTY

[Former Member]

I am having trouble migrating script to BPC 10.1 NW. In this example (validated in UJKT), COMPANY_ETC is the Entity dimension and INTCO in the Intercompany dimension.

The *IS portion of the statement produces the following error:

     UJK_VALIDATION_EXCEPTION:Invalid when/endwhen - Line #15 : Only "=" supported here

Script:

*SELECT(%NON_ELIM_SR_ENTITIES%, [ID], COMPANY_ETC,[SEGMENT] <> '' AND [SEG_ELIM] <> 'X' AND [CALC]='N' AND [ID] <> BAS(443) AND [ID] <> BAS(370))

*SELECT(%SR_INTOC%, [ID], INTCO,[SEGMENT] <> '' AND [CALC]='N' AND [ID] <> I_443 AND [ID] <> I_370)

*SELECT(%COMP_SEG%, [SEGMENT], COMPANY_ETC,[ID] = %NON_ELIM_SR_ENTITIES%)

*SELECT(%ELIM_ACCS%, [ID], ACCOUNT_ETC,[ELIMACC] <>'')

*XDIM_MEMBERSET INTCO=%SR_INTOC%

*XDIM_MEMBERSET COMPANY_ETC=%NON_ELIM_SR_ENTITIES%

*XDIM_MEMBERSET ACCOUNT_ETC=%ELIM_ACCS%

*XDIM_MEMBERSET RPTCURRENCY=USD

*XDIM_MEMBERSET DATASRC=GL

*XDIM_MEMBERSET CATEGORY = ACTUAL_SCRIPTS

*WHEN COMPANY_ETC.SEGMENT

*IS INTCO.SEGMENT

    *REC(FACTOR=-1,COMPANY_ETC=COMPANY_ETC.INTRA_SEG_ELIM_ID)

*ELSE

    *REC(FACTOR=-1,COMPANY_ETC=COMPANY_ETC.SEG_ELIM_ID)

*ENDWHEN

*COMMIT

[former_member186338 · Accepted solution]

Ups, try for test without ELSE:

*WHEN COMPANY_ETC.SEGMENT

*IS INTCO.SEGMENT

    *REC(FACTOR=-1,COMPANY_ETC=COMPANY_ETC.INTRA_SEG_ELIM_ID)

*ENDWHEN

[Former Member · Accepted solution]

It does work without the ELSE, I assume it is because the ELSE is equivalent to <>, which throws the Only "=" supported here error.

Thank you for the help!

[former_member186338 · Accepted solution]

Just forget that this specific case works only without ELSE!

You have to write 2 loops - First - for all, then only for same property...

It works the same way in BPC NW10

[former_member186338]

You are using undocumented syntax:

*WHEN COMPANY_ETC.SEGMENT

*IS INTCO.SEGMENT

Unfortunately it works with some SP and produce error on another...

In BPC 10 in most cases it's OK.

[former_member186338]

By the way, please provide detailed version info about your BPC...