I have this particular scenario with a Destination_App logic case I am moving data from SOURCE to TARGET Model A to Model B the tricky part is that the dimensions are not the same.
I need to send data from Source Model to Target Model using DESTINATION_APP but the members coming from the one Source Model Dimension JOB_CODE need to be filtered by a property "PARENTH1 = IUP" and its records "mapped" or moved to a Target Model MPU_UNIT Dimension in which the "only" members that should be affected are the ones which "ID" property is matching with "DESC" property of the incoming members from JOB_CODE from the Source Model.
Is this possible?and if so, would my code work satisfied the requirement? Thanks in advance.
Dimensions in Source Model
Dimensions in Target Model
*XDIM_MEMBERSET AUDIT_TRAIL = RATE_NPD,RATE_DBP,RATE_DDF *XDIM_MEMBERSET CURRENCY = LC *XDIM_MEMBERSET POSITION_ID = PINR *XDIM_MEMBERSET POSITION_TYPE = PTNR *XDIM_MEMBERSET MEASURE = PERIODIC *XDIM_FILTER JOB_CODE = [JOB_CODE].PROPERTIES("PARENTH1")="IUP" *DESTINATION_APP = MPU *ADD_DIM MPU_COMP = CCNR *ADD_DIM MPU_COST = MSA *SKIP_DIM = ORG_UNIT *SKIP_DIM = POSITION_ACTION *SKIP_DIM = POSITION_ID *SKIP_DIM = POSITION_TYPE *RENAME_DIM JOB_CODE = MPU_UNIT *WHEN TIME *IS * *REC(EXPRESSION=%VALUE%,JOB_CODE=JOB_CODE.MPU_UNIT) *ENDWHEN *COMMIT