Skip to Content
2

Unable to remove Version and Cross calculations from the Global Filter

Apr 16 at 12:13 PM

57

avatar image

Hello,

We were trying to build a Planning Input Schedule using the Grid View. we were trying to get custom column combinations using Restricted measures, for example I would want to see Actual 2017 Actual 2018 only as first two columns and then the rest of the columns would be Plan 2018 for the 12 months.

Taking Actual and Plan as versions would expand Actual 2017 and Plan 2017 for all months and Actual 2018 and Plan 2018 for all months. Hence by doing we have to created Restricted measures for Actual 2017 and Actual 2018. But by doing so , it moves the version to the Global filter with filter selected as Plan and the option to remove from the filter is not available.

we tried creating a rolling forecast where we took forward 8 months from current month. It created the Restricted measures for the corresponding months. which is static as it does not have the time range selection of current month in it. . However we noticed that the version is not added to the Global filter in this case. How do we have the option of removing the Version and cross calculation from the Global filter while using restricted measures?

Also can we make the rolling forecast dynamic, where we create a rolling forecast after selecting some actual months and inserting a rolling forecast from that month which is dynamic, list a Forecast starting point , shifting the forecast period from month to month.

10 |10000 characters needed characters left characters exceeded

Were you able to figure this out?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

John Leggio
Apr 16 at 05:18 PM
0

Hi Shankar,

Please see the following help page to create a dynamic forecast layout:
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2018.5/en-US/3e2ad3b322494a4cad6b1a1ebffe93e1.html

You can add CutOverDate / CutOverDateVer properties to your version dimension (double click on an empty column in the version dimension to add them)

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hello John,

Apologies for the delayed response, but seems the link is not valid. It gives a message as the page you are looking is not found.

0

Hi,

here's the new redirect for that feature https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/3e2ad3b322494a4cad6b1a1ebffe93e1.html


It would be great if you could add a couple of screenshots to capture your problem

regards, H

1
Vadim Kalinin Apr 16 at 02:25 PM
0

What product you are talking about? Some tags are incorrect!

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I was trying to create this scenario in SAP Analytics on Cloud - I selected a planning model and was developing the story in the Grid View

0
Shankar Goutam Ayapilla
0