Skip to Content
0
Apr 29, 2014 at 04:04 PM

EPM Script Logic for dis-aggregation

31 Views

Dear All

I was trying to write script for dis-aggregation logic, but somehow its not working. Can someone plz help me.

I have flat file which contains my dimension members and a factor in one column. This column is factor present in model . ONce the file loads into bpc, it should check this factor in system and multiply signdned for this record with that factor value and post it into same dimensions but dummy factor member. and rest all dimensions keep as it is. Here is sample input.

CATEGORY COSTCENTER ACCOUNT FUND ORDER WRKB TIMEPERIOD VALUE DATASRC CAT_A 1000 1234 GD1 OD01 W01 2014.YEAR 12000 F01 CAT_B 1000 1234 GD1 OD01 W01 2015.YEAR 10000 F02

FACTOR % IN DB JAN FEB MAR APR MAY JUN JUL AUG SEPT OCT NOV DEC TOTAL F01 10 5 5 10 10 10 5 10 10 5 10 10 100 F02 5 10 10 5 5 15 5 10 10 5 10 10 100

RESULT CATEGORY COSTCENTER ACCOUNT FUND ORDER WRKB TIMEPERIOD VALUE DATASRC CAT_A 1000 1234 GD1 OD01 W01 2014.01 1200 F_DUMMY CAT_A 1000 1234 GD1 OD01 W01 2014.02 600 F_DUMMY

ATTACHED SAMPLE I/O

Attachments