Hello Friends,
I am atemtpping to generate a Script Logic on SAP BPC that replies all the data from a specific category to the next year, following one Factor previously definided.
Until now, I am able to do the forecast for all the next year (year +1), but the source is only one month. (December). And my porpuse is to get a source that are all the months from that year, divided by 12 (the 12 months of the year).
the script I have so far is this:
*XDIM_MEMBERSET TIME=%TIME_SET%
*SELECT(%INFLAT%,"RATE","P_A_CATEGORY","ID='FORECAST'")
*XDIM_MEMBERSET P_A_DATASRC=REC
*XDIM_MEMBERSET P_A_CATEGORY=PFA
*WHEN TIME
*IS %YEAR%.DEC
*FOR %MONTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC
*REC(FACTOR = %INFLAT%, P_A_CATEGORY=FORECAST, TIME= "%YEAR%(+1).%MONTH%")
*NEXT
*ENDWHEN
*COMMIT
it works, but as I said it only considers as source the "%YEAR%.DEC" month.
My sugest is, continue with that month, but in a YTD prespective (but my application is PERIODIC), or consider all months, and divide the data by 12, or at the Factor, divide it by 12.
Waiting for your help.
Thanks in advance.
João Silva