Skip to Content

Rolling forecast requirement in BPC Embedded

Hi Experts,

We have following forecast requirement in BPC embedded.

Expecting Output in AO form as below:

Columns:

Version: V0(Actuals), VWPG(IM),VR09(Forecast),VPCY(Budget)

Time: Based on Version property ‘Mstart’ planning horizon should be derived.

Example: If Mstart is 2018.10

->Template should display actuals for 2018.10 to rest of the year.

->Template should allow input for IM version 2018.10 to rest of the year.

->Template should display VR09, VPCY for 2018.10 to rest of the year.

Row axis:

Entity,WBS,Partner and accounts.

Solution:

Row structure of query will be –Entity, WBS , Partner and account

Column structure: How to achieve this rolling forecast scenario?

Do we need to use restricted keyfigures or formulas how can we achieve this forecasting requirement?

Please help if you have already developed this kind of solution.

Thanks,

Siva

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Oct 16, 2018 at 04:34 PM
    Add comment
    10|10000 characters needed characters exceeded