Skip to Content
0
Former Member
Sep 10, 2010 at 03:32 PM

Complication in Copying data from one App to another

25 Views

The ENTITY dimension in APP1 has properties CSTCTR, BRND and CHNNL which have values that map to the COSTCTR, BRAND and CHANNEL dimensions members in APP2.

How can I write the logic to copy data from APP1 to APP2. The script below does not work.

*DESTINATION_APP=APP2

*RENAME_DIM ENTITY=COSTCTR, ENTITY=BRAND, ENTITY=CHANNEL

*WHEN *

*IS *

*REC(ENTITY=ENTITY.CSTCTR, ENTITY=ENTITY.BRND, ENTITY.CHNNL)

*ENDWHEN

*COMMIT

So, Iu2019m basically renaming Entity to 3 dimensions, each requiring the use of a property to determine the destination dimension members. Any ideas on how I can achieve this?

thanks, Agnes