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..