Pipeline and Revenue Forecasting
In this use case, we focus on how the pipeline could affect the sales revenues in the upcoming weeks, months
and quarters.
Automated Analytics
Manipulating the Data
Launch SAP Predictive Analytics
Choose the
Data Manager
section
Select
Load an existing Data Manipulation
In the
Load existing
Data Manipulation
window, select your SAP HANA instance and connect using
the <Domain User> account via the
Browse
button
Ensure that the following data manipulations are available
Scenario
Data Manipulation
Sales Forecast Aggregated
DM_SALESORDER_FORECAST_AGGREGATED
Sales Forecast by Sales Organization
DM_SALESORDER_FORECAST_SALESORG_MON
THLY
Sales Forecast by Material Group
DM_SALESORDER_FORECAST_MATGRP_MONTH
LY
Building the Predictive Model
From the home screen of SAP Predictive Analytics, select the
Modeler
section
Select
Create a Time Series Analysis
In the
Select a Data Source
window,
Choose
Browse
and connect to your SAP HANA instance using the <Domain User> logon
Then select the
Browse
button again to select the data set that will be used for predictive modeling.
Scenario
Data Manipulation
Sales Forecast Aggregated
DM_SALESORDER_FORECAST_AGGREGATED
Sales Forecast by Sales
Organization
DM_SALESORDER_FORECAST_SALESORG_MONTHLY
Sales Forecast by Material
Group
DM_SALESORDER_FORECAST_MATGRP_MONTHLY
Choose
Next
to continue.
Enter the attribute prompt value to filter the data set, for example
FromPeriod, ToPeriod, SalesOrg,
MatGrp
and so on.
After entering the value, choose
OK
to begin modeling
Choose
Analyze
and a description for the data set appears.
Choose
Next
when the data description accurately describes the data
