How to Implement the Linear Regression Technique in SAP Integrated Business Planning for Demand
- by Manish Thukral, Principal Consultant, Infosys Technologies
- Rahul Patil, Senior Consultant, Infosys Technologies
- April 21, 2017
SAP Integrated Business Planning for demand is the equivalent of SAP Advanced Planning and Optimization (SAP APO) Demand Planning. While SAP APO has an out-of-the-box forecast model that uses a linear regression technique to forecast, SAP Integrated Business Planning does not have it. The purpose of this article is to understand the solution approach to forecast based on linear regression in SAP Integrated Business Planning. The approach for doing linear regression in SAP Integrated Business Planning is to use the multiple linear regression as an alternative solution.
Reading this article, you’ll learn how to:
- Create a data model that includes creation of attributes, master data, time profile, planning area, key figures, and planning levels
- Create a forecast model for linear regression in generating a forecast
- Execute a statistical forecast using the SAP Integrated Business Planning add-in for Microsoft Excel user interface
- Validate the forecast results
A forecast model is the configuration that defines the following parameters that are used during a statistical forecast engine run: general parameters, preprocessing steps, forecasting steps, and postprocessing steps. In the forecast steps, algorithms and variables are defined for use in linear regression-based forecasting.
Statistical forecasting is a demand planning process to predict the numbers of anticipated sales in a future time horizon based on past data. In forecasting there are different methodologies to arrive at forecast numbers. One of them is regression analysis of the past data points of a variable based on what forecast numbers are calculated. There are two types of variables. One is an independent variable and another is a dependent variable.
In regression analysis the linear relationship is established between dependent and independent variables to consider the impact of the independent variable on the forecast. If there is one independent variable used in forecasting method, then that method is called a simple linear regression. If there are multiple independent variables, then that method is called multiple linear regression. SAP Advanced Planning and Optimization (SAP APO) has two different forecasting models, one for simple linear regression and another for multiple linear regression. SAP Integrated Business Planning provides a built-in forecasting model for multiple linear regression only, but there is no forecast model based on the linear regression method.
We show the use of a multiple linear regression model with one variable to work as a simple linear regression model in SAP Integrated Business Planning.
Log in to the SAP Integrated Business Planning cloud and open the Model Configuration group of apps. To complete this step, click the triangle to the right of Communication Manager in the menu bar and select Model Configuration from the drop-down list of options (Figure 1).
Select Model Configuration in the main SAP Integrated Business Planning apps screen
This action displays the screen shown in Figure 2.
Model Configuration apps
In Figure 2, click the Configuration tile to open the Configuration app shown in Figure 3. Model Configuration apps help you create a planning model in SAP Integrated Business Planning. A planning model describes what are the planning levels, input—output information, how data is stored, and calculation.
Configuration showing links for planning model entities
Would you like to see this full item?