APO DP Proportional Factor calculation and its use to disaggregate Forecast

[Former Member]

Hi,

Can anyone please explain me, how the Proportional Factor is being calculated and how it is used to disaggregate at detailed level.

Suppose, 9 weeks sales data is considered for Proportional Factor calculation.And after getting the Proportional Factor calculated,how to use that for a particular keyfigure(for example Forecast on detailed level for different buckets).

An example with manual calculation,is appreciated.

Thanks

Pravas

[alok_jaiswal · Accepted solution]

Hi Pravas,

Will try to explain with same example -

Suppose you have total 6 CVC for a given combination as given belwo-

	P1	P2
Total	10	20
CVC1	1	4
CVC2	1	4
CVC3	2	3
CVC4	2	3
CVC5	2	3
CVC6	2	3

Fixed proportion -

Total count for all CVCs = 20 + 10 = 30

Sum for each CVC across all period = 5

So, proportional factor = 5/30 = 16.66%

So, if you have another keyfigure which is based on keyfigure APODPDANT, it will be disaggregated in thi proportion.

Detailed Proportion -

Here proportional factor for CVC are time - dependent. In this calculation for period 1 - calculation would be -

1^st CVC – 1/10

2^nd CVC – 1/10

3^rd CVC – 2/10

4^th CVC – 2/10

5^th CVC – 2/10

6^th CVC – 2/10

Note - You can use Fixed proportion without parallel processing to view detailed logs after executing proportional factor to see how calculation is being performed.

Hope it helps you.

Regards,

Alok

[Former Member · Accepted solution]

Thank you Alok. It looks quite convincing.

Regards

Pravas

[Former Member]

Thank you Amol and Alok.

Regards

Pravas

[Former Member]

Hi Pavas

Please find below the link which will provide more detail information regarding Proportional Factor calculation.

https://help.sap.com/saphelp_scm70/helpdata/en/cb/3bc95360267614e10000000a174cb4/frameset.htm

In case the information is helpful, please close the thread as per information.

Thanks

Amol

[Former Member]

Thank you Amol

Regards

Pravas