Show TOC

Procedure documentationGenerating an Intelligent Forecast

 

Note Note

This function is available only if you are using SAP Business One, version for SAP HANA.

End of the note.

Prerequisites

  • You have installed the Application Function Library (AFL), which includes the SAP HANA Predictive Analysis Library (PAL). For more information about the database role PAL_ROLE, look for the SAP Business One Administrator's Guide, version for SAP HANA on sappartneredge.comInformation published on non-SAP site.

  • In the SAP HANA Studio, you have activated the script server in your SAP HANA instance. See SAP Note 1650957Information published on SAP site for further information.

Procedure

  1. In the Forecasts window, choose the Generate Forecast button, and choose Intelligent Forecast.

    The Intelligent Forecast window appears.

    Note Note

    For more information about other actions that need to be performed in the Forecasts window, see Managing Forecasts.

    End of the note.

  2. In the Configuration area, perform the following. For more information, see Intelligent Forecast Window.

    • In the Select Items By dropdown list, use the selection criteria to filter items to be included in the forecast. You may filter items by Item, Preferred Vendor, or Default Warehouse.

    • Select the Warehouse checkbox to generate forecasts for filtered items in specific warehouses. If the checkbox is deselected, only the item's default warehouse is considered in the forecast. If the item does not have a default warehouse, then the company's default warehouse is considered in the forecast.

    • In the Sales History section, define the historic sales records as the calculation basis for the forecast.

    • In the Calc. Method dropdown list, select the algorithm to be used in the forecast.

      Recommendation Recommendation

      Use the automatic selection of calculation methods, which will apply the most suitable method and its parameters based on the historic data.

      End of the recommendation.

  3. To generate the forecast, choose the Forecast button.

  4. In the Forecast Values area, you can find the generated forecast quantities for each item in specific warehouses in each time bucket. For more information, see Intelligent Forecast Window.

  5. Select one row in the Forecast Values area to display its graphic statistics below. By default, the first row is selected.

    In the graphic area, the forecast is displayed in the orange area, and the forecast data is indicated by an orange line.

  6. [Optional] In the graphic area, you can perform the following. For more information, see Intelligent Forecast Window.

    • To generate the forecast based on sales records of a different history period, modify the maximum history time bucket number and choose the Forecast button.

    • To generate the forecast based on a different calculation method, choose Change and define parameters in the Customized Forecast window.

      After you change the parameters, the row in the Forecast Values area is tagged with an orange triangle, indicating that the calculation method has been customized.

    • To customize past data, drag the amount to an adjusted value.

      The forecast is updated and the customized data is indicated by a dotted line.

    • To test the accuracy of the calculation method, drag the arrow next to the orange forecast area.

      A blue area appears, displaying both the actual data and forecast data based on past data to the left of the blue area.

  7. [Optional] In the lower right corner, to save the settings in the Configuration area, and the parameters you changed in the Customized Forecast window, choose Save As A Template.

  8. To save data and return to the Forecasts window, in the lower left corner, choose Save and Close.

    SAP Business One, version for SAP HANA populates this window with the forecast values.

More Information

Managing Forecasts

Intelligent Forecast Window