Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SCRIPT LOGIC - Rolling FORECAST

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question