I need some help with Destination app script logic to copy data from MODEL_A to MODEL_B.
Model Dimensions
------
I need to copy a record set below from Model A to Model B using Destination App.
The record set in model A is below screenshot. Notice that
FNO_STATUS, D_VALUE, PROJECTTYPE are total node in Source model and can be skipped. ( I may be wrong on that)
RPTCURR, FNO_DATASRC, FNO_CATEGORY, ACCOUNT are constant values.
TIME should be a single value selection from the DOM package selection prompt.
Only a specific combination of REGION and FUNCTION from MODEL A should be transferred to a specific combination of BUSINESSUNIT and PID in Model B (Destination)
This is what I have so far..
( Wont let me copy paste so I had to type it here... sorry for any typos)
*XDIM_MEMBERSET FNO_STATUS = BAS(TOT_STATUS)
*XDIM_MEMBERSET D_VALUE = BAS(TOT_VALUE)
*XDIM_MEMBERSER PROJECTTYPE = BAS(TOTAL_PRJTYPE)
*XDIM_MEMBERSET RPTCUR = USD
*XDIM_MEMBERSET FNO_DATASRC = BAS(TOTAL_ADJ)
*XDIM_MEMBERSET FNO_CATEGORY = ACTUAL
*XDIM_MEMBERSET BENEFITTYPE = BAS(TOT_REGION)
*XDIM_MEMBERSET REGION = BAS(TOT_REGION)
*XDIM_MEMBERSET FNO_FUNCTION = BAS(LOG), BAS(MLP), REF
*XDIM_MEMBERSET FNO_ACCOUNT = BI_NON_CAPITAL
*XDIM_MEMBERSET TIME = 2016.JAN
*DESTINATION_APP = MODEL_B
*ADD_DIM DATASRC = D_IMT
*ADD_DIM CATEGORY= ACTUAL
*SKIP_DIM FNO_STATUS, D_VALUE, PROJECTTYPE, BENEFITTYPE
-----