SAP Analytics Cloud

Predictive Planning – How to keep a private version after publishing predictive forecasts?

The goal of this blog is to explain how to keep the private version of a planning model to which predictive forecasts were generated. Predictive forecasts are generated from historical data contained in the planning model, and are written back to a private version of this planning model. To retrieve those forecasts in a public version, the planner must publish the private version. A side effect of the publication is the deletion of the private version once it is copied to a public version. So, if planners want to revisit the predictive settings to get better forecasts, they have to restart from the beginning. There is a simple way to avoid this rework, as you can see from the figure below.

Fig 1: Workaround to keep the private version used by the Predictive Scenario

There is a new step before the publication of the private version. It involves the creation of a copy of the private version. It is this duplicated private version that will be published as a public version, and then deleted. The original private version is then still available to store new forecasts. So, the planner could go back to the first private version if needed.

Let see an example of how this works.

The use case is about forecasting car sales in European countries by car brands. The planner has historical data since 2015, and the objective is to forecast sales in 2020 by country and brand. The screenshot below shows a story on the planning model. You can see here the “Actual” version of the data, but in general, the planner won’t work directly on this version. Instead they will work on a copy called here “Forecast”.

Fig 2: Story on planning model with Actual and Forecast versions

The planner creates a private version as shown below. It will be their working version in which predictive forecasts will be generated. So, there is no need to copy historical data in this version.

Fig 3: Creation of the private version of the planning

As soon as the planner clicks on the “OK” button, the private version called “Car Sales Private” is created.

Fig 4: Private version created

The planner saves the planning story and creates a Predictive Scenario. They choose a time series Predictive Scenario and name it “Car Sales”. They then select the planning model as data source, and the version with historical data that will be analyzed to create the forecast. This is the public version named “Forecast”.

Fig 5: Predictive Scenario is created using the public version “Forecast” for historical data

The planner then chooses the account member “SALES” as signal (value to predict), and the date dimension “DATE”. As the planner wants to predict the full year 2020, the number of forecasts is 12 months. The planner wants predictions for all valid combinations of country and brand. Thus, they select the dimensions “COUNTRY” and “BRAND” in the “Entity” field. In the end, the settings panel looks like this.

Fig 6: Setting panel of the Predictive Scenario

The planner selects the “Train & Forecast” button to build a predictive model. After a while, they can inspect the explanation pages for each country and brand, and get the sales forecasts for 2020.

Fig 7: Predictive model for 2020 for Germany and Porsche

Assuming the planner is happy with these predictive forecasts, they want to report them into their working version of the planning model. To do that, they click on the “Apply” button, and they select the private version of the planning model.

Fig 8: Create forecasts and save them in the private version of the planning model

Once done, the planner goes back to the planning story to see the private version updated with the predictive forecasts.

Fig 9: Sales forecasts reported on the private version of the planning model

The planner can now use planning features like allocation process to adapt and refine the private version to meet their expectations and their objectives.

Once ready, if the planner publishes now, the publish mechanism updates the public version with the data of the private version, and will delete this private version. Note that there is also a “Publish as” that creates a new public version, but the private version is deleted in the end. If the planner wants to come back to the Predictive Scenario to refine it to get better predictive forecasts, they need to repeat the complete process. So, they have to recreate the private version, to share it with other planners, and to recreate the predictive scenario. This might be required, for example, every month when the planning is updated with actual values, and the planner wants to get new predictive forecasts. However, if they just want to adjust predictive settings, it’s a waste of time. To avoid this, the planner will first duplicate the private version as shown below.

Fig 10: Duplicate the private version

There are now two private versions:

  1. Car Sales Private which is linked to the Predictive Scenario
  2. Car Sales Private (copy) just created
Fig 11: Two private versions

In the Version management panel, the planner selects the copy of the private version, and clicks on the “Publish” button.

Fig 12: Publication of the copy of the private version

Then they choose the public version of the planning.

Fig 13: Publish on the working public version named “Forecast”

The content of the private version now appears as a public version, and the copy of the private version has been deleted.

Fig 14: Predictions and adjustments published and copy of private version deleted
Rating: 0 / 5 (0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *