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.
After any change to this table, you should regenerate the plan to assure the planning engine works with the latest definitions of the measures.
In addition to the measures you define in this table, the forecasting engine uses a number of standard measures.
- Calculation of the statistical forecast:This process uses as input historical demand, which is read from the sum of “orderstotal” and “ordersadjustment” measures.The statistical forecast populated in the measure “forecastbaseline”.
- Calculation of the forecast consumption:This process reads as input the measure “forecasttotal”, and all open sales orders will consume from this gross forecast. By default “forecasttotal” is computed as “if(forecastoverride == -1, forecastbaseline, forecastoverride)”, but you can easily use a different formula.The output is populated in the “forecastnet” and “forecastconsumed” measures.
- Calculation of the supply planning:This process considers the measure “forecastnet” as the remaining sales forecast to plan.The outputs of the process goes in many tables, and also populates the measures “forecastplanned” and “ordersplanned”.
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.|
Define the storage and calculation behavior this measure.
Visibility and editability policy for the current and past time periods.
Visibility and editability policy for the current and future time periods.
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.|
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.
For computed measures, this expression defines how the value is computed.
The expression can use the following:
Here are some concrete examples:
This expression is evaluated when the computed measure is updated by the user.
It will use assignments to update the the measures used in the compute-expression. The variable newvalue is populated with the new value provided by the user.
An example shows how the update expression basically inverses the compute expression: