Skip to Content
Author's profile photo Varun Anand

Forecasting using Predictive Functions in Lumira 1.31

Forecasting is the process of making predictions of the future based on past and present data and analysis of trends – Wikipedia


As an extension to the data discovery aspects of Lumira, we can perform basic predictions or forecasts using the Predictive Calculation option.

There are three important forecast methods available in Lumira,

1) Linear Regression

Simple Linear Regression fits a straight line through the set of n points in such a way that makes the sum of squared residuals of the model (that is, vertical distances between the points of the data set and the fitted line) as small as possible. – Wikipedia


2) Triple Exponential Smoothing

Exponential smoothing is a rule of thumb technique for smoothing time series data, particularly for recursively applying as many as three low-pass with exponential window functions. It is an easily learned and easily applied procedure for approximately calculating or recalling some value, or for making some determination based on prior assumptions by the user, such as seasonality. Wikipedia

3) Using SAP Predictive Analytics

This would be one of the most accurate methods of forecasting. But the accuracy depends on the size of the historical data, the larger the size of the data the better. If the number of data points is lesser than 16 or if the pattern is not visible we can use option 2 instead.


For a more advanced forecasting and leveraging other predictive algorithms, I would use a tool like SAP Predictive Analytics.


Certain conditions do need to be satisfied before forecasting,


This is the error message suggesting the changes that you would need to leverage the predictive capabilities.

To start with basic prediction, we can use a Line Graph across Month as the time dimension for more data points. We can extend this concept across other relevant charts or measures.


Under the measures we can see the option for Predictive Calculation,



We can select the Forecast method and the interval of prediction as follows,


The forecasted values will be visible on the chart and can be accessed under the measure axis. The following chart shows predictions based on the Forecast methods,


The method of forecasting depends on the situation. I would use smoothing method for month-month forecast of sales numbers and use regression for a more granular level analysis involving variables which are positively or negatively tied together.

Assigned Tags

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

      Thanks for the article.  Another useful read is this old blog linked above . It explains the correct conditions for producing a trustworthy forecast using 'tripe exponential smoothing'



      Author's profile photo Former Member
      Former Member

      Great write Varun, This came very handy for one of my Lumira development.

      Keep up the good work.



      Author's profile photo Former Member
      Former Member

      Hi Varun,


      Your article is simply superb.

      But I want to know much deep about 3 below  predictive techniques.

      1) Linear Regression

      2) Triple Exponential Smoothing

      3) Using SAP Predictive Analytics

      Please share some insights and useful articles.


      Thanks in advance

      Author's profile photo POD AAES
      POD AAES

      Is Predictive function available with Lumira version 2.1? Or we will have to install separately?


      Author's profile photo Varun Anand
      Varun Anand
      Blog Post Author

      These are not available in the 2.1 version currently. SAP is planning to cover the functional parity between 1.x and 2.x versions. So, we would need to expect these functionality mostly in the next releases.