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