Skip to Content
0

Destination_APP issue in Script logic

Dec 01, 2017 at 06:02 AM

18

avatar image
Former Member

Hi All,

I have 13 dimension in Source App in periodic model and i want to copy the data from Source app to target app which has consolidated YTD model with 9 standard dimensions for consolidations.

below is th emy code in Script logic.

*XDIM_MEMBERSET CATEGORY = ACTUAL

*SELECT(%TT%,"[ID]",TIME,"[YEAR]=$YY$ AND [PERIOD]<=$MM$ AND [CALC]='N'")

*XDIM_MEMBERSET TIME=%TT% *DESTINATION_APP = CONSOLIDATION

*SKIP_DIM = COST_CENTER,CUSTOMER,RAWMATERIAL,ENTITY,PROFITCENTER

*ADD_DIM SCOPE=S_None,CONS_ENTITY=DUMMY,FLOW=NO_FLOW

*RENAME_DIM RCH_ACCOUNT=CONS_ACCOUNT

*WHEN CATEGORY

*IS * //already scoped

*REC(EXPRESSION=%VALUE%,AUDITTRAIL=DATA, TIME=$YY$.$MM$)

*ENDWHEN

getiing this ERROR "Invalid dimension defination in Destination_APP: CONSOLIDATION.

Please help me onthis. thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Dec 01, 2017 at 08:00 AM
0
Share
10 |10000 characters needed characters left characters exceeded