Calculation of proportional factor for disaggregation of the forecast

[Former Member]

Hi everyone

Is it possible to use historical data (for a fixed interval in the past) for the calculation of a proportional factor and to copy this factor in the future in order to disaggregate the forecast? E.g. Use Historical data to calculate the Proportional factor based in the last 12 months and use  the obtained proportions to disaggregate the forecast in the next 12 months. How would the syntax concretely  look like with the following Input/output key figures?

Input Key figures

Actual year: Jan to Dec 2014

HISTORYDATA@PERPRODCHANCUST (Period/Product/Channel/Customer)

HISTORYDATA@PERPRODCHANCUST (Period/Product/Channel)

Future Year Jan bis Dec 2015

FORECAST@PERPRODCHAN (Period/Product/Channel)

Output key figures

Future year: jan to dec 2015

FORECAST@PERPRODCHAN (Period/Product/Channel)

PROPFACT@PERPRODCHANCUST (Period/Product/Channel/Customer)

Thanks in advance

Kenneth

[Irmi_Kuntze · Accepted solution]

Hi Kenneth

1) you can use statistical FC means with input data your histoy and you outputr your proportional factor if you want e.g. to have an average of the last 13 or 24 months, with use of moving average simply, if you want to have a constant value

2) you can use a calculated KF that copies from history to proportional factor by shifting by one year, using PERIODID shift. THere are example in the SAP model for a year-1 lag calculation

3) You can do as in 2, but in addition make use of any additional formula according to your needs

4) you can NOT have a dynamic calculation, because prerequisite for disaggregation is that you keyfigure used in the fisaggregation

- is stored and not calculated

- has the same base planning level than the KF itself

Yours

Irmi