Unexpected scope when using *DESTINATION_APP

[Former Member]

Dear experts,

My goal is to sum up all incomes from all sub-business and bring the calculated value to another model.

The problem is although I have specified all sub-business members in *XDIM_MEMBERSET, the *destination_app still use the user-defined scope when calculating the summation.

For example, if user submit the income of the sub-business TYPE1 only, only incomes of sub-business "TYPE1" are summed instead of all sub-business TYPE1,TYPE2,TYPE3,TYPE4.

However I need to sum all incomes of all sub-business regardless of what users submit.

How can I fix it?

Here is my script logic.

*XDIM_MEMBERSET Category=ACTUAL

*XDIM_MEMBERSET InputCurrency=HKD

*XDIM_MEMBERSET NEW_ENTITY=DEFAULT

*XDIM_MEMBERSET Time=GENERAL

*XDIM_MEMBERSET SUBBUSI = TYPE1,TYPE2,TYPE3,TYPE4

*XDIM_MEMBERSET PLANACCT = INCOME_Y1,INCOME_Y2,INCOME_Y3

*DESTINATION_APP = GLOBALMODEL

*SKIP_DIM = SUBBUSI

*RENAME_DIM PLANACCT = GLOBALACCT

*WHEN PLANACCT

*IS INCOME_Y1,INCOME_Y2,INCOME_Y3

*REC (EXPRESSION = %VALUE%, PLANACCT=PLANACCT.TOTAL1)

*ENDWHEN

*COMMIT

Regards,

Gordon

[former_member186338]

Hi Gordon,

You script is in default.lgf? Please, always explain it...

Also what is in TOTAL1 property of the PLANACCT?

If the script is not in the default.lgf then it's 99% correct and have to produce correct results:

*XDIM_MEMBERSET Category=ACTUAL

*XDIM_MEMBERSET InputCurrency=HKD

*XDIM_MEMBERSET NEW_ENTITY=DEFAULT

*XDIM_MEMBERSET Time=GENERAL

*XDIM_MEMBERSET SUBBUSI = TYPE1,TYPE2,TYPE3,TYPE4

*XDIM_MEMBERSET PLANACCT = INCOME_Y1,INCOME_Y2,INCOME_Y3

*DESTINATION_APP = GLOBALMODEL

*SKIP_DIM = SUBBUSI

*RENAME_DIM PLANACCT = GLOBALACCT

*WHEN PLANACCT

*IS * //INCOME_Y1,INCOME_Y2,INCOME_Y3 - already scoped

*REC (EXPRESSION = %VALUE%, PLANACCT=PLANACCT.TOTAL1)

*ENDWHEN

//*COMMIT - NEVER use useless COMMIT!!!

Please show UJKT log.

B.R. Vadim