Maintain Historical Data

You can maintain historical data internally using manual entry in a forecast item, or externally in separate records using a separate data table, an external database, or an external file.

To use an external source, you must first create a record in the Forecast Database using a record type such as Import or Data Table.

See Import Records.

See Data Table Record.

You import data from an external source and refer to a particular time-series by typing a formula using the following syntax:

Source.Item

Where Source is the name of the external data source record, such as an Import item, and Item is the time-series name, such as a product name.

For example:

UnitSales.SKU100

Note: To use this functionality, you must have appropriate permissions set by your Administrator.