How to: Set Up Retail Forecast Dimension Entries

In this article

To download Retail Forecast Dimension Entries from external APIs

To import Retail Forecast Dimension Entries from files

To delete Retail Forecast Dimension Entries

See also

Retail Forecast Dimension Entries contain the values of Retail Forecast Dimension for each day. You decide how the values for the dimensions are obtained, that is downloaded from external APIs or imported from files.

To download Retail Forecast Dimension Entries from external APIs

  1. Click the icon, enter Retail Forecast Dimensions, and select the relevant link.
  2. Select a dimension in the list, click the Related action, and then the Dimension Entries action to open the list of entries.
  3. Click the Maintenance action, and then click the Download action.

The Retail Forecast Dimension Entries page has the following fields:

Field Description
Dimension Code This field specifies the unique dimension code.
Date This field specifies the date of the dimension's value.
Value This field specifies the dimension's value.

You can automate the download of a dimension's values for a specific Retail Forecast Dimension by using a Scheduler job:

  1. Click the icon, enter Scheduler Job List, and select the relevant link.
  2. Create a new Scheduler job by clicking the New action, or select an existing job.
  3. In the General FastTab, define the Job ID and Description.
  4. Select or create a new Scheduler Job Type Code.
  5. In the Object Setup FastTab, select Codeunit in the Object Type field, and assign the Object No. with 10012234 (LSC Forecast Dim Val. Download).
  6. In the Object Setup FastTab, fill the Code field with the unique dimension code.
  7. Go to the Schedule Details FastTab, define the date and time when you would like the job to be executed. This includes Time Units, Time Between Check, Next Check Date, and Next Check Time.

To import Retail Forecast Dimension Entries from files

  1. Click the icon, enter Retail Forecast Dimensions, and select the relevant link.
  2. Select a dimension in the list, click the Related action, and then the Dimension Entries action to open the list of entries.
  3. Click the Maintenance action, and then click the Import action.
  4. Choose a .csv file that contains the entries to be imported. The file must have a header and 3 columns: Dimension Code, Date, Value.

To delete Retail Forecast Dimension Entries

The Retail Forecast Dimension Entries can be deleted periodically by setting up the Scheduler job DELETELOGS and the Days Forecast Dimension Entries Exist field in the Retail Forecast Setup page.

  1. Click the icon, enter Retail Forecast Setup, and select the relevant link.
  2. In the General FastTab, fill in the Days Forecast Dimension Entries Exist field. This field specifies how far back in days to keep the Retail Forecast Dimension Entries. All entries older than the defined period will be deleted, if you enable the Scheduler job DELETELOGS.

See also

How to: Set Up Retail Forecast Dimensions

How to: Extend Retail Forecast Dimensions

Retail Forecast