Copy data from app A to app B with dimension ID linked with dimens property

18 Views

Hi expert,

This is my script.....

*XDim_Memberset TIME = %ThisYear%.JAN,%ThisYear%.FEB,%ThisYear%.MAR,%ThisYear%.APR,%ThisYear%.MAY,%ThisYear%.JUN,%ThisYear%.JUL,%ThisYear%.AUG,%ThisYear%.SEP,%ThisYear%.OCT,%ThisYear%.NOV,%ThisYear%.DEC

*XDim_Memberset entity = PP2

*XDim_Memberset INTCO = NON_INTERCO

*XDim_Memberset datasrc = Input

*XDim_Memberset category = BGT

*XDim_Memberset PRODUCT = CMB110

*XDim_Memberset RAWMATERIAL =CMB000_INT

*XDim_Memberset Rptcurrency = MYR

*XDim_Memberset PLANITEM = SP111002

*DESTINATION_APP = FINANCE

*SKIP_DIM= RAWMATERIAL,PRODUCT

*ADD_DIM CAPEX=No_CAPEX

*ADD_DIM CUSTOMERS=No_Cuctomers

*RENAME_DIM PLANITEM= ACCOUNT.PLANITEM //........... problem ???

*ADD_DIM COSTCENTER = GSPC_7000

*WHEN POS(TIME)

*IS >=POS(%FirstPlanMonth%)

*When planitem

*is SP111002

*Rec(FACTOR=1)

*Endwhen //planitem

*Endwhen //POS

*Commit

This script is actualy I want to copy data from operation APP to finance APP

the linkage is between planitem with account..

In my operation app i have dimension planitem ,no account dimension..

In my finance app i have dimension account, no planitem dimension..

The account dimension have a property call PLANITEM is to link with planitem dimension in Operations APP

from example above planitem = SP111002

i want to copy this data TO finance APP into

account.ID = AC123 on which the account.planitem = SP111002

the linkage is

account.plaitem = plaintem.ID

This link is not ID with ID ,but is property wih ID..

script

*RENAME_DIM PLANITEM= ACCOUNT.PLANITEM //........... problem ???

i dunt think it work as i want....

Is it possible to do this without adding new property in PLANITEM dimension call ACCOUNT..

Thanks....