on 12-01-2017 6:02 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.