Skip to Content
Author's profile photo Flavia Moser

SAP Analytics Cloud – Predictive Forecasting: Time Series Forecasting

Time Series Forecasting on SAP Analytics Cloud

Time series forecasting is a new capability in SAP Analytics Cloud for planning. The forecasting function uses SAP’s proprietary time series technology to analyze trends, cycles, and fluctuations in time series data. Utilizing historic data, it predicts future values using the SAP HCP predictive services. Embedded in a business user-friendly interface, users can simply select their desired forecasting periods and click run without having to choose between different time series algorithms. Thus, this functionality assists business users in making more data-driven decisions especially when combined with their business planning processes.

 

What is the difference between a predictive and planning forecast?

Let’s get a better understanding on the difference between predictive and planning forecasting. Predictive forecasting and planning forecasts go hand in hand. A planning forecast uses historical data, business acumen, planning models, and predictive forecasting to determine future outcomes. In addition, planning functions such as spreading, distributions, and allocations are also key in helping to build a planning forecast – all of them available today in the product. Predictive forecasts run a time series algorithm on historic data that considers trends, cycles and/or fluctuations to predict future values. The future values predicted through a predictive forecast can then be leveraged to help business users take a more data-drive approach in the business planning process.  Below is a visual diagram of how predictive forecasting and planning forecasts relate to one another.

 

TimeSeries_PredictivePlanning.jpg

 

 

 

Scenario: Expense forecasting for data-driven budget planning

In this scenario, we are in the role of a business user who is planning their company budget for the rest of the year. We want to know what the company’s forecasted travel expenses will be for the next few months using time series forecasting, this will help us better plan our budget and ensure we are optimizing our company’s financial resources.

 

Setting Up:

  • Create a “New Story” and select “Add Grid”
  • Click “Insert” and select the “Concur_Predictive” model to import the travel expense data we are going to perform the forecast on

 

TS1.jpg

 

Next, we add the time dimension under columns in order to break down and analyze our travel expense by quarters and months.

  • Select “Builder”
  • Click “Add Dimensions” and select “Time” as the additional dimension to add

TS2.jpg

Before we start our time series forecasting, we should create a private version of this data so that we don’t accidentally make changes to the actual data set. We do this by:

  • Clicking on Version Management under the Plan tab section to create a copy of the Actuals data

TS3.jpg

With this current data set, we have travel expense data available until April of 2016 and we want to forecast the travel expense for after April. We can do this with our predictive technologies through clicking on Forecast to start our time series forecasting.

  • Select the cell that shows our total Travel Expense, in this scenario cell C6
  • Click on the time series forecasting icon

TS4.jpg

After clicking the time series icon, a dialogue will open which automatically identifies the last date we have data for and will start forecasting from that date until a future date that we choose. For this scenario, we want to forecast until the end of the year which will look something like this:

TS5.jpg

After clicking ‘Preview’, the time series algorithms returns the best model by analyzing cycles, trends, and fluctuations. Once the analysis is completed, we will be able to see what the model forecasts as our travel expenses to be until the end of the year and will also provide us with the confidence interval along with it.

 

TS6.jpg

Clicking “Ok” will copy the forecasted values into your previously specified version.

 

Additional Resources:

Further details on the time series algorithm can be found here:

https://blogs.sap.com/2017/05/31/looking-under-the-hood-of-automated-time-series-from-sap-predictive-analytics

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Henry Banks
      Henry Banks

      hi Flavia, is this type of predictive forecast for "Planning models" only?  the reason i ask is that I have an analytical model based on RemoteBW and can't get this function active..

      Author's profile photo John Leggio
      John Leggio

      Hi Henry, Yes predictive forecasts only work for Planning models: https://cp.hana.ondemand.com/dps/d/preview/1949b084ea3343df9e83923e906b7a03/release/en-US/frameset.htm?c103ce86ba2f4fdabe8bbdcd54fa7429.html

      See also:

      2315434 - SAP Cloud for Analytics 2016.09 release information

      • You can run a predictive forecast on a private-version cell in a Story grid.
      Author's profile photo Henry Banks
      Henry Banks

      Thanks John.   Do you know if there are plans to enhance this?

      i'm seeing a lot of non-planning, pure-analytics license subscriptions with my customer evaluations, so this limitation isn't ideal.  Cheers, H

      Author's profile photo Flavia Moser
      Flavia Moser
      Blog Post Author

      Thanks for your feedback, Henry. Yes, there are enhancements planned in the future.

      Flavia

      Author's profile photo Former Member
      Former Member

      Hi Flavia,

      Great Blog !!

      Just a clarification, Do we have a control on how much past data can be used to simulate the forecast, or will it be always all the complete data existing in system prior to my forecasting window.

      Regards

      Nikhil

      Author's profile photo Former Member
      Former Member

      Hi Nikhil,

      By selecting "Show more options" in the pop-up forecasting window, you can select which past period to begin simulating the forecast period with. However, just keep in mind there needs to be a sufficient amount of past data for the time series algorithms to analyze patterns and produce a most robust model.

      Best,

      Flora

      Author's profile photo Ashwini Pingle
      Ashwini Pingle

      Hi Flavia,

      Thanks for the blog!!

      I am curious to know the significance of BPC module (Bus. Planning and Consolidation) in case we have predictive analytics embedded in Cloud. Does this replace BPC in the longer run?

      Regards,

      Ashwini Pingle

      Author's profile photo Henry Banks
      Henry Banks

      Hi,

      No, BPC has it's own product-specific roadmap, and leans more in the direction of S/4HANA and its strategy to use the embedded BW.

      that's my understanding anyway!

      Regards,

      H

      Author's profile photo Former Member
      Former Member

      Hi,

      We are trying to import a simple model with structure

       

      Product, Date, Sales Value

      When the model is created from a excel file and we try to generate the predictive it throws below error.

      Can you let us know whats the accepted date type accepted?

       

      Thanks

      Abhi

      Author's profile photo John Leggio
      John Leggio

      Hi Abhi,

      Your model is at the day level granularity in the time dimension.

      That’s not supported.

      Documented here: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/c103ce86ba2f4fdabe8bbdcd54fa7429.html

       

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Abhi, this is a use case that can be addressed by using Smart Predict on one end and SAC/Planning on the other end. See the video here: https://www.sapanalytics.cloud/resources-incorporating-predictions/

      Kind regards,

      Antoine