on 07-13-2010 9:31 AM
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..
close message
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When you copy elements from one application to other you are copying just base members.
I think using
RENAME_DIM PRODUCT= CUSTOMERS.PARENTH2
That's means you will not copy anything because into databse you don't have into Source any value for CUSTOMERS.PARENTH2 (this is not a base member).
I think this is the problem.
Regards
Sorin Radulescu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
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.