Skip to Content
avatar image
Former Member

Destination_APP issue in Script logic

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 01, 2017 at 08:00 AM
    Add comment
    10|10000 characters needed characters exceeded