Skip to Content
0
Former Member
May 16, 2016 at 04:49 PM

Script logic - Destination app ?

586 Views

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

-----

Attachments

img1.jpg (120.4 kB)
img2.jpg (309.3 kB)