I have following requirements:
The user will input following using 2 Input Schedules:Input Data
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%
*REC(FACTOR=1,PRICE_TYPE=RATE,RATE_TYPE = %Q1%)