Skip to Content
0
Jan 19, 2018 at 02:27 PM

DESTINATION_APP mapping member from different accounts and models based on their properties

83 Views Last edit Jan 19, 2018 at 05:48 PM 3 rev

Hi gurus,

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.

The Requirement:

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.

The question:

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

Attachments

position-model.png (24.0 kB)
mpu.png (22.2 kB)