Skip to Content
0
Former Member
May 12, 2016 at 06:59 PM

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

81 Views

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