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.
*RENAME_DIM ENTITY=COSTCTR, ENTITY=BRAND, ENTITY=CHANNEL
*REC(ENTITY=ENTITY.CSTCTR, ENTITY=ENTITY.BRND, ENTITY.CHNNL)
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?