Skip to Content
0
Former Member
Apr 30, 2012 at 06:45 PM

Script Logic help

28 Views

Hi all,

I have following requirements:

The user will input following using 2 Input Schedules:

Input Data
















IDENTIFIER UOM BUDGET_PERIOD R_ENTITY KPBI PRICE_TYPE RATE_TYPE MEASURES PLAN_CYCLE SIGNED DATA MY PERCENT 2012.01 GLOBAL INT_RATE OPR NA PERIODIC 2012 10 MY PERCENT 2012.01 GLOBAL INT_RATE SPREAD FD PERIODIC 2012 20 MY PERCENT 2012.01 GLOBAL INT_RATE SPREAD BR PERIODIC 2012 20 MY PERCENT 2012.01 GLOBAL INT_RATE SPREAD KL1 PERIODIC 2012 20 MY PERCENT 2012.01 GLOBAL INT_RATE SPREAD KL2 PERIODIC 2012 20

Now the script logic is going to run through DP Manager and should have following output.

It should lookup the value for PRICE_TYPE = OPR and RATE_TYPE=NA and add it with the values in PRICE_TYPE=SPREAD and RATE_TYPE=FD/BR/KL1/KL2(depending on the user input in datapackage manager which is a Userdefined Dimension) and store it as follows:

IDENTIFIER UOM BUDGET_PERIOD R_ENTITY KPBI PRICE_TYPE RATE_TYPE MEASURES PLAN_CYCLE SIGNED DATA MY PERCENT 2012.01 GLOBAL INT_RATE RATE FD PERIODIC 2012 30 MY PERCENT 2012.01 GLOBAL INT_RATE RATE BR PERIODIC 2012 30 MY PERCENT 2012.01 GLOBAL INT_RATE RATE KL1 PERIODIC 2012 30 MY PERCENT 2012.01 GLOBAL INT_RATE RATE KL2 PERIODIC 2012 30

I tried the following script logic but it doesn't work

*FOR %Q1% = FDR, BRR, KL3, KL6
*XDIM_MEMBERSET PRICE_TYPE=OPR, %Q1%
*WHEN PRICE_TYPE
*IS *
*REC(FACTOR=1,PRICE_TYPE=RATE,RATE_TYPE = %Q1%)
*ENDWHEN
*COMMIT
*NEXT

Please help,

Diksha.