Show TOC

Procedure documentationUsing the Forecast Strategy Locate this document in the navigation structure

 

The dashboard designer allows you to use the Forecast strategy in the Design Dashboard section to make forecasts based on your existing data.

Prerequisites

  • You have installed the SAP HANA Predictive Analysis Library (PAL). For more information about the Predictive Analysis Library, see SAP HANA Predictive Analysis Library (PAL) Reference on the SAP Help Portal at http://help.sap.com/hana_appliance.

  • In the Design Dashboard section of the dashboard designer, the type of all target dimensions must be DATE.

For prerequisites when using the dashboard designer, see Designing Pervasive Dashboards Using the Dashboard Designer.

Procedure

For more information about other operations in the dashboard designer, see Designing Pervasive Dashboards Using the Dashboard Designer.

  1. In the Select Base Data Source section of the dashboard designer, select the query or view based on which you want to design a pervasive dashboard.

  2. In the Design Dashboard section, in the Strategy Type dropdown list, select Forecast.

    Note that only DATE type dimensions appear in the Target Dimensions area.

    The forecast data is displayed in red.

    You can change the data display unit to Year, Quarter, and Month in sequence.

    Note Note

    The Forecast strategy only supports the column and line charts.

    End of the note.

  3. In the Advanced Settings area, you can define the following:

    • Alpha, Beta, Gamma: three factors used in the forecasting calculation. For detailed information about the calculation, see the Double Exponential Smoothing, and Triple Exponential Smoothing sections in SAP HANA Predictive Analysis Library (PAL) Reference on the SAP Help Portal at http://help.sap.com/hana_appliance.

    • Forecasting Base Cycle: the cycle used for forecasting. You can change the cycle according to your own situation. For example, if your production cycle is six months, and you have defined the smallest display unit as Month, you define the base cycle as 6, and the forecast will be calculated on a six-month cycle basis.

      The default cycle is determined by the smallest display unit you selected in the Target Dimensions area. For example, the default cycle is 4 when the smallest display unit is Quarter, and the default cycle is 12 when the smallest display unit is Month.

      For cycle 1, the Double Exponential Smoothing calculation is used. For cycles other than 1, the Triple Exponential Smoothing calculation is used.

      Note Note

      The number of the smallest display units with data in the database must be greater than or equal to the forecasting base cycle multiplied by 2.

      End of the note.

    • Forecasting Period: the number of display units to be forecast.

  4. Save the dashboard or go on to the Add Links step.