Simulating Data with SAP Analytics Compass

Objective

After completing this lesson, you will be able to describe the difference between a compass simulation and a time series prediction and know when to use them.

What is SAP Analytics Cloud Compass?

Compass is a native SAP Analytics Cloud feature which enables the simulation of probable impact brought about by driver uncertainties. It utilizes the relationship defined between the driver and target within the SAP Analytics Cloud model. With compass, you are able to perform scenario modeling of different assumptions and compare the probable outcomes.

Create simulations from a story table or the compass start page to answer business questions that you may have. You are able to simulate uncertainties in key drivers and the impact probability right away without additional IT setup or prior mathematical definitions.

Compass simulation. Scenarios on the left, drivers for the selected scenario in the middle and the results on the right.

Compass Simulations and Time Series Forecast Predictions

It is important to remember that a compass simulation is not the same thing as a time series forecast prediction.

Time series forecasts project the data trend from historical values into the future. It is not reliant on existing mathematical definition between the KPIs. You need to have enough historical data to detect the trend for the desired period into the future. The kind of business questions leading to a time series prediction center around what happens if things develop at more or less the same rate.

Time series forecasts provide answers when you want to know what will happen in the future if the current trend persists. An example of a question you would ask when using a time series forecast prediction could be, What is the predicted operating income if the trend for COGS development in the past 4 years persists?

SAP Analytics Cloud compass simulations use the Monte Carlo simulation, a mathematical simulation method delivering a range of probable outcomes as result. It does not analyze data trends, but instead, relies on repeated calculation using random inputs. This also means that a formula or definition of relation between the impacted KPI and the drivers is required before the simulation can be executed. As this method explores possible outcomes brought about by random inputs, the business questions leading to a compass simulation should center around what happens if things change.

SAP Analytics Cloud compass provide answers when you what to know the probable impact if there are uncertainties to driver performances. An example of a question you would ask when using a Monte Carlo simulation could be, What are the probable results of operating income if the COGS is between 10 to 20 million dollars?

Some typical use cases for compass include understanding the risk context during target setting, budget reviews, strategic or workforce planning, just to name a few. Basically, compass is not limited to any use case, as long as the relationship between target and driver(s) are defined within the SAP Analytics Cloud model.

In summary:

 Compass SimulationTime Series Prediction
Does it require historical data to analyze trends?NoYes
Does it require defined mathematical relationship between influencer/drivers and the target KPI?YesNo

Can you use time series forecasts and compass simulations together? Yes, you can use both to enhance the attainable insights. For example, you could generate a time series forecast for an observation of what would happen in the future if the current trend persists and then perform a compass simulation on top of the predicted version to understand the risk context if a few key drivers are unexpectedly impacted.

SAP Analytics Cloud Compass

In the following video, we will show you how to use SAP Analytics Cloud compass simulations.

Run a Compass Simulation

Business Scenario: You have been provided with information that may affect the forecast numbers for the year. You learn that there will be an increase in the cost of raw materials and some churn in the EMEA region. You also know that there is a possibility of a substantial increase in gross sales in the US due to potential deals.

You want to simulate the potential impact and using the range of uncertainties provided by your team. You create a compass scenario to explore the impact of an increase in raw material cost, an expected churn in EMEA, and a potential sales increase in the US.

Task Flow: In this practice exercise, you will perform the following tasks:

  • Create a compass simulation from a story table
  • Explore in the interface
  • Add restricted drivers
  • Update Value Configuration for drivers
  • Run the simulation
  • Interact with the probability chart

Additional Learning

SAP Analytics Cloud compass is covered in more detail in the Forecasting and Simulating Planning Data unit in the Leveraging SAP Analytics Cloud Functionality for Enterprise Planning learning journey.

Log in to track your progress & complete quizzes