Hi SAC Fans,
This time a short SAC blog but I think it will be useful for some Story Designers. 🙂
I have received a question if it is possible to create a What-If-Simulation based on a SAC Live Model based on SAP BW.
I can think of different ways to solve this (few examples):
- Work with formula values in the SAP BW Query. They can be used in a SAC story and can be changed via runtime.
- Create a Analytics Designer applications.
- Stay in SAC Story mode and do not touch the SAP BW query.
Let’s take the easiest way and work with a SAC Story.
Our initial SAC story looks like this:
You can see in the table that the SAP BW Query has the measure “Profit” inside which is fine.
In addition you can see the dimension “Sales Person” in the rows.
What we need to do, is to create a new calculation. Lets start:
In the next step we will define our calculation. Let’s take the “Profit” inside the formula editor:
Now we need to multiply the Profit with an Input Control. We need to add one:
In the next step we will give our Input Control a name. I call it “Bonus Simulation“.
We use a “Static List” and in the next step we select “Select by Range“:
The range should be between “0” and “100“. As increment we enter “1” and then we click on “OK“.
The screen should look like this. Click on “OK” and leave the editor.
In the next step we include the input control into our formula:
Finish the formula and enter a name for the new calculattion. Click on “OK” to leave the editor:
We can see that the new calculation is available in the table. And we can see the inpu control which we need to resize and move it under the table.
The next step is easy for all who are familiar with SAC.
I move the input control under the calculation in the table.
Then I change the size, the background color, the text color, remove the symbol (via “Show/Hide” by using the context menu of the input control) and it should look like this.
If we now move the slide, the values will change according our selection. So our “What-If” works already.
But as we need to visualize our data as well, let’s add a chart and format it a little bit.
As measure I select our newely created measure and as dimension the “Sales Person”.
And we are done. If we now change the input control, the change will be shown immediately in the table and in the chart.
And that’s it. We have created a Bonus What-If Simulation based on SAP BW Live data in SAP Analytics Cloud. I took this easy example to illustrate how it works.
The following video shows the result for those who want to see it without building content in SAC 🙂
You can do much more by working with this approach. Hope you liked it.