Forecast and Demand History Review

Forecast and Demand History Review allows users to view both demand forecast and history in the same timeline view.

Complete the following steps to view forecast and demand history reviews:

  1. L og in to the ONE system.

  2. Click Menus/Favs > Demand Planning > Forecast and Demand History Review. In the NEO UI, users can click on the Menus/Favs icon on the left sidebar and type in the name of the screen in the menu search bar. For more information, see "Using the Menu Search Bar."
    The Forecast and Demand History Review screen appears.

    images/download/attachments/131836198/2023-02-02_15-20-33-version-1-modificationdate-1675376483000-api-v2.png


  3. Fill out the following fields. Fields with an asterisk ( * ) are required.

    Field

    Description

    Product Group Type

    Enter or select a product group type using the picker tool.

    Item Name

    Enter or select an item name using the picker tool.

    DC

    Enter or select a distribution center (DC) using the picker tool.

    * Source

    Enter or select a data source from the dropdown menu.

    * Forecast Component

    Select a forecast component from the dropdown menu.

    Planned Forecast Scenario

    Enter or use the picker tool to select a planned forecast scenario.

    Partner Site

    Enter or use the picker tool to select a partner site.

    * Timeline

    1. Click the calendar tool to set a date range.
      A popup displays, and both fields are required.

      images/download/attachments/131836198/2023-02-02_14-58-26-version-1-modificationdate-1675377640000-api-v2.png



    2. Select a time bucket for * Bucketization from the dropdown list.

    3. Use the calendar tool to select the beginning and end dates for the * Date Range.

    Product Group Level

    Enter or select a product group level using the picker tool.

    Site Group Level

    Enter or select a site group level using the picker tool.

    Forecast Bucketization

    Select a time bucket from the dropdown list.

    * Quantity UOM

    Enter or select a unit of measure from the dropdown menu. Custom UOMs are supported in this field when properly configured.

    * Forecast Source

    Enter or select a forecast source from the dropdown menu.

    Partner

    Enter or use the picker tool to select a partner.

    Future Event Flag

    Select this checkbox only to display forecasts with events in the future.

  4. Click the Search link.
    The search results appear.

    images/download/attachments/131836198/2023-02-02_15-49-08-version-1-modificationdate-1675378238000-api-v2.png



  5. Click the Customize button.
    The Customization Level popup displays.

    images/download/attachments/131836198/2023-01-27_16-41-51-version-1-modificationdate-1675379825000-api-v2.png



  6. Select the appropriate level, and click the OK button.
    The screen refreshes with customization tools.

    images/download/attachments/131836198/2023-02-02_15-54-01-version-1-modificationdate-1675381615000-api-v2.png



  7. Click the eye icon to hide and unhide the data measure.

  8. Click the plus icon and select an option to add a data measure above or below this data measure.
    The Add Data Measure popup displays.

    images/download/attachments/131836198/crop-version-1-modificationdate-1675381666000-api-v2.png



  9. Fill out the following fields. Fields with an asterisk ( * ) are required.

    Field

    Description

    * Data Measure Type

    Select a data measure type from the dropdown menu.

    * Name

    Enter a name for the data measure

    Display Name

    Enter a different name to display on the report if desired.

    Group

    Check the box to allow child data measures to be added to this data measure.

    *Expression

    Click the tabs (Data Measure, Function, and Constants) in the pane on the right to build a mathematical expression from the lists. Instructions are provided for each tab.

  10. Click the Add button.
    The data measure is added as a new row.

  11. Click the Attributes button.
    The Customize Attributes popup displays.

    images/download/attachments/131836198/2023-02-02_16-36-32-version-1-modificationdate-1675381775000-api-v2.png



  12. In the Visible column, click a cell and check or uncheck the box.
    A check displays Yes, and no check displays No.

  13. Click the OK button.
    The screen refreshes to display or hide your selections.

  14. Click the Manage button to display the added customizations in a new tab.
    The Manage Customization screen appears in a new tab.

    images/download/attachments/131836198/image-2022-11-21_9-11-17-version-1-modificationdate-1675379827000-api-v2.png



  15. In the Actions column, click the Delete link to delete a customization.

  16. Click the Export to CSV button to export the report to a CSV file.

  17. Returning to the Forecast and Demand History Review screen, click the Finish Customizing button.
    The TLV updates.

  18. Click the Save button.
    The screen refreshes.

  19. Click the Export to Excel button to export the data to a file on your computer.