Skip to Content
0
Former Member
Apr 02, 2014 at 06:06 AM

Unexpected scope when using *DESTINATION_APP

15 Views

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