Skip to Content
0
Jul 02, 2020 at 01:32 PM

Dynamic Forecast Layout - How can I specify time ranges for my versions?

343 Views Last edit Jul 08, 2020 at 12:07 PM 3 rev

Hello all,

In my table where I used the planning model I would like to display three versions: actual, forecast1 and forecast2 and be able to define the start date and end date for this two forecast versions. I used the following help as a starting point:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.12/en-US/3e2ad3b322494a4cad6b1a1ebffe93e1.html?css=https://better-decisions.eu10.hcs.cloud.sap/sap/fpa/services/rest/epm/feature/css?tenant=15

I have already set up properties in the model:

As far as I understood, in the past I should use the cross calculation + calculation input control + formula option to do it:

I guess at the moment the forecast layout should be used:

I would be more than grateful if somebody could help me with the following:

1) How should the formula FIND look like to be able to work on time ranges if I will use the cross calculation?

2) How should settings for a forecast layout look like if I will decide to do it in that way? I guess the formula would be the same as in the point 1) for forecast1 but what about the forecast2? I know that I can add additional versions, but I cannot really specified cut over date.

Thank in advance for helping me out.

Best regards,

Paula

Attachments

1.jpg (34.8 kB)
2.jpg (49.3 kB)
3.jpg (38.5 kB)
4.jpg (11.6 kB)