Rolling forecast in SAP BPC 10.0 NW

[Former Member]

Hello experts

We have a requirement to display Cash Flow reports in the form of rolling forecast.

The periods is fixed ie (2016.01 to 2016.12) but category changes from Actual to Plan . for eg. If the user selects the month as June then the category for Jan to May will be actual and June to Dec will be plan. If the user selects the month as Aug, then the category for Jan to July will be actual and Aug to Dec will be plan.

Any help/links on how to create such dynamic report will be highly helpful.

Regards

ATG

[akos_beres]

ATG,

Look for the Rolling 12 video on the below page

EPM Add-in Academy - Enterprise Performance Management - SCN Wiki

Akos

[Former Member]

Hi ATG,

You can achieved this by IF condition,Just see my my example.

Thanks

Khokan

[former_member186338]

Hi Khokan,

If you look on the formula in my sample: "= EPMOlapMemberO(IF(RIGHT(B$8;2)<RIGHT($A$6;2);"Actual";"Plan");"[CATEGORY].[].[ACTUAL]";"Actual";"";"000")"

you will see that the comparison is done without any extra cells used

Vadim

[former_member186338]

Please read my post here:

You can use Excel formulas to calculate the required CATEGORY member in static column header.

Vadim

[former_member186338]

Sample:

Vadim

P.S. In A6:  =EPMContextMember(;"TIME")