Predictive Planning in SAP Analytics Cloud is the most popular Augmented Analytics Use Case for my customers and me. However, until recently, one thing made my life a bit hard. I could only manually trigger my predictions. Consequently, I had to go back to my Predictive Scenario and restart it by hand. For the first few times, this might make sense. Yet, when I gained trust in the predictions, I want to run them automatically regularly. So, they give me the prediction every quarter for instance. Luckily this is now possible, and in this post, it is my pleasure to show you how 😊.
In this post, we created a Predictive Planning Model, which is the basis for the following steps. So, if you haven’t done this yet, please follow the steps in the hands-on tutorial. You need a Predictive Planning Model before you can following this one.
In this case we have everything prepared so we can start with the actual scheduling for the predictive model.
In the menu on the left, we select “Multi Action”. Depending on the size of your screen it can be found in the menu directly or in my case under the 3 three dots.
From the “Multi Actions” screen we select “Create New”.
On the right, we can give our “Multi Action” a name like “Predictive Planning Scheduling” and we could add a description.
“Multi Actions” are powerful, and you can perform a lot more. For our case, we select “Add Predictive Step” on the top left.
On the right we can now give this Step a name, I decided for “Predictive Planning”. Then we can choose our predictive model. We navigate to our folder with our predictive models and select the “product_planning_forecast” we already trained as described in the Predictive Planning Hans-On. Then we select “Model 1” as “Predictive Model” and “Actuals” as ”Version To Save Forecast”.
Then we click the “Save” icon on the top left.
We could now use this “Multi Action” and include it in a story. This is handy when you want to trigger it manually as a controller from your SAC Planning Dashboard. In our case, we are using this step to check if our “Multi Action” runs smoothly.
We open our Planning Story and make sure we are in edit mode. If not, we select the “Edit” button on the top right.
Under the “+” Icon we select “Planing Trigger”.
And then “Multi Action Trigger”.
In the builder tab on the right we can now select our “Multi Action”.
After this, we can click the start button for our selected “Multi Action”.
This might take a second. If you did everything correctly you will get your new predictions in the table. Since we changed nothing in the data, don’t be surprised if the results look like the old predictions from the Predictive Planning Hands-On Tutorial.
Of course, we won't trigger our predictions always manually from the story. Ideally, we want to schedule it to run automatically. Hence, we select “Calendar” in the menu on the left, under the three dots.
Before we can leave our story, the tool asks if we want to publish our data. For this Hands-On tutorial it doesn’t matter what you choose, so I leave it up to you.
In the calendar, we can see all the scheduled tasks and their execution time. We want to apply our Predictive Planning “Multi Action Task" regularly. Therefore, we select under the “+” icon “Multi Action Task”.
We again give it a name like ”Schedule Predictive Planning” and select our start date.
Now we want to select “+Add Recurrence”. In my case I want this predictive scenario to run once a quarter for the next 2 years. That is why I selected as shown in this screenshot.
Then we click on “Ok” followed by “Create”.
Now we can see our schedule for Predictive Planning in the calendar, and it will be automatically executed every quarter for the next two years.
I hope you are excited as much about this feature as I am.
Have fun scheduling your Predictive Planning model.
In this post, we created a Predictive Planning Model, which is the basis for the following steps. So, if you haven’t done this yet, please follow the steps in the hands-on tutorial. You need a Predictive Planning Model before you can following this one.
In this case we have everything prepared so we can start with the actual scheduling for the predictive model.
In the menu on the left, we select “Multi Action”. Depending on the size of your screen it can be found in the menu directly or in my case under the 3 three dots.
From the “Multi Actions” screen we select “Create New”.
On the right, we can give our “Multi Action” a name like “Predictive Planning Scheduling” and we could add a description.
“Multi Actions” are powerful, and you can perform a lot more. For our case, we select “Add Predictive Step” on the top left.
On the right we can now give this Step a name, I decided for “Predictive Planning”. Then we can choose our predictive model. We navigate to our folder with our predictive models and select the “product_planning_forecast” we already trained as described in the Predictive Planning Hans-On. Then we select “Model 1” as “Predictive Model” and “Actuals” as ”Version To Save Forecast”.
Then we click the “Save” icon on the top left.
We could now use this “Multi Action” and include it in a story. This is handy when you want to trigger it manually as a controller from your SAC Planning Dashboard. In our case, we are using this step to check if our “Multi Action” runs smoothly.
We open our Planning Story and make sure we are in edit mode. If not, we select the “Edit” button on the top right.
Under the “+” Icon we select “Planing Trigger”.
And then “Multi Action Trigger”.
In the builder tab on the right we can now select our “Multi Action”.
After this, we can click the start button for our selected “Multi Action”.
This might take a second. If you did everything correctly you will get your new predictions in the table. Since we changed nothing in the data, don’t be surprised if the results look like the old predictions from the Predictive Planning Hands-On Tutorial.
Of course, we won't trigger our predictions always manually from the story. Ideally, we want to schedule it to run automatically. Hence, we select “Calendar” in the menu on the left, under the three dots.
Before we can leave our story, the tool asks if we want to publish our data. For this Hands-On tutorial it doesn’t matter what you choose, so I leave it up to you.
In the calendar, we can see all the scheduled tasks and their execution time. We want to apply our Predictive Planning “Multi Action Task" regularly. Therefore, we select under the “+” icon “Multi Action Task”.
We again give it a name like ”Schedule Predictive Planning” and select our start date.
Now we want to select “+Add Recurrence”. In my case I want this predictive scenario to run once a quarter for the next 2 years. That is why I selected as shown in this screenshot.
Then we click on “Ok” followed by “Create”.
Now we can see our schedule for Predictive Planning in the calendar, and it will be automatically executed every quarter for the next two years.
I hope you are excited as much about this feature as I am.
Have fun scheduling your Predictive Planning model.
- SAP Managed Tags:
7 Comments
