Forecast measures
Forecast measures define numeric value that are stored for specified item + location + customer + time bucket combinations.
FrePPLe provides a number of standard measures. With this table you can add project-specific values to manage more complex demand forecasting processes and workflows.
The measures are visible and editable in the Forecast editor, Forecast report and Inventory planning screen.
Important
After any change to this table, you should regenerate the plan to assure the planning engine works with the latest definitions of the measures.
Fields
Field |
Type |
Description |
---|---|---|
name |
non-empty string |
A unique name.
The measure data are stored using this key in the database. Only
alfanumeric characters are allowed.
|
label |
string |
The string used in the user interface. This will be translated automatically to the language configured in your browser. |
description |
string |
Free text description. |
type |
string |
Define the storage and calculation behavior this measure.
|
mode_past |
string |
Visibility and editability policy for the current and past time periods.
|
mode_future |
string |
Visibility and editability policy for the current and future time periods.
|
formatter |
string |
Controls how the values should be displayed. Accepted values are “number” (default) and “currency”. |
discrete |
bool |
Specifies whether fractional numbers are acceptable for this measure or not. |
defaultvalue |
number |
Specifies the value for the measure when it is left unspecified for a certain item + location + customer + time bucket combinations. 0 is the default value. If the default value is -1, unspecified cells will display as an empty cell. |
compute expression |
string |
For computed measures, this expression defines how the value is computed. The expression can use the following:
Here are some concrete examples:
|
update expression |
string |
Currently unused. |