1. PlanIQ
  2. Prepare your data
  3. Create a module for your forecast results

Have a module prepared to export your forecast results into. You can save your results in the module as soon as you've run your predictions.

Your feedback is important to us. To ensure you have a good content experience, we'd appreciate if you could tell us how you find the guidance on this page and if it addresses your questions. 

To take part, complete the quick survey at the end of the article, and tell us how we can improve. 

Ensure you're in the New Modeling Experience (NMX) and you're familiar with how to build a model in Anaplan. 

This module is mandatory. The procedure is similar to setting up the modules for your source data. 

To create a forecast results module:

  1. Create a new module and import a time dimension and an ID list as rows.
    For the ID list, you can also use an existing list of SKUs or items. 
  2. Create up to three line items for each quantile prediction. Call the line items P1, P2 and P3 and make them columns.
    Use these line items to contain the forecast results for the prediction quantiles you applied when you configure a forecast action. P1 contains the forecasts for the lower quantile, P2 for the middle quantile (0.5) and P3 for the upper quantile.
  3. Configure an import action.
    This action imports your forecast results into this module.
    You can import the results from the different forecast runs with this action.

To configure the import action:

  1. Create a new CSV file.
    You can create CSV files in Excel.
    Use this file for to create your column headers.
  2. Add column headers for the following data items:
    • Timestamp
    • ID list (item_id)
      Name this column with the name of your ID list. For example, SKUs.
    • P1
    • P2
    • P3
      P1, P2, and P3 represent the three prediction quantiles you can apply to your forecast.
  3. In the module, select Data>Import to import the CSV file. 
  4. Select Upload New File... and upload the CSV file. 
  5. Select the Mapping tab and map the source columns to the target columns:
SourceTarget
Column 1: timestampTime
Column 2: item_iditem_id  
(Column headers)Forecast results line items (P1, P2, P3)
  1. Select the Time tab and select Dates.
    Ensure the date format is Y-M-D.

CSV template

Use this CSV file as a template to set up your import action.