Skip to Content
0
Former Member
Jul 13, 2010 at 08:31 AM

copy from appA to AppB raise a issued

27 Views

Hi expert,

please see below script

*XDim_Memberset TIME = 2010.Mar

*XDim_Memberset entity =PP2

*XDim_Memberset datasrc = Input

*XDim_Memberset category = %CATEGORY_SET%

*XDim_Memberset PRODUCT = <ALL>

*XDim_Memberset TRANSPORTER =<ALL>

*XDim_Memberset CUSTOMERS =<ALL>

*XDim_Memberset SALESPERSON =<ALL>

*XDim_Memberset Rptcurrency = MYR

*XDim_Memberset PLANITEM = SP111002,SP111004,SP111005,SP121002,SP201004

*DESTINATION_APP = OPERATIONS

*RENAME_DIM PRODUCT= CUSTOMERS.PARENTH2

*SKIP_DIM= CUSTOMERS,SALESPERSON,TRANSPORTER -


> Customers

*ADD_DIM INTCO = NON_INTERCO, RAWMATERIAL = NO_RAWMAT

*WHEN *

*IS *

*REC(FACTOR=1)

*ENDWHEN

*Commit

The problem here is I get error "This key is already associated with an element of this collection"

i think because i skip customers then i use RENAME_DIM PRODUCT= CUSTOMERS.PARENTH2

if i change:

//*RENAME_DIM PRODUCT= CUSTOMERS.PARENTH2

*SKIP_DIM= CUSTOMERS,SALESPERSON,TRANSPORTER

it work ok ....

if i change:

*RENAME_DIM PRODUCT= CUSTOMERS.PARENTH2

*SKIP_DIM= SALESPERSON,TRANSPORTER

i still get error "This key is already associated with an element of this collection"

i think because my destination do not have DIMENSION customers.

I need customers.parenth2 become my destination product..

any idea??

Thanks..