on 2017 Dec 01 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.
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 7 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 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.