Skip to Content
0
Apr 22, 2020 at 05:57 AM

Rolling forecast In Sap BPC Embedded (Using PAK or IP or Fox Logic)

73 Views Last edit Apr 22, 2020 at 05:59 AM 2 rev

Hi Experts,

I'm trying to calculate a forecast based on the 5 previous months and version equal to actual.

Input Structure:

Version Gl Account FISCPER Amount

Actual , 752 , 009.2019 , 5,00

Actual , 752 , 010.2019 , 10,00

Actual , 752 , 011.2019 , 15,00

Actual , 752 , 012.2019 , 5,00

Actual , 752 , 001.2020 , 7,00

Actual , 752 , 002.2020 , 10,00

Let's say I want to calculate the forecast for the next 4 months for each Gl account and version should be FC

Output Structure :

Version Gl Account FISCPER Amount

FC , 752 , 003.2020 , 9,40

FC , 752 , 004.2020 , 9,40

FC ,752 , 05.2020 , 9,40

FC , 752 , 06.2020 , 9,40
I tried to develop using forecast function (Moving average ) but it works only existing data and rolling up to futer periods. Could you please provide your expert opinion to achieve this.

Regards,

Raja

Thank you,