Queries used in navigation
These queries are defined in the Planning Engine definition. Forecast Consumption is included
in the Forecast Consumption template.
| Query | Category | Query Result |
|---|---|---|
| Valid Demand Groups | Navigation | Returns a count where Demand Groups.nb of base level > 0. The nb of base level property is a count of base level combinations in each Demand Group. |
| History Bucket Without Total Orders | Alert | Returns a count where Demand Groups.history bucket without total orders > 0.
The value of history bucket without total orders property is 1, if the value of total orders is zero for a history bucket. |
| Unusual Forecast | Alert | Returns a count where Demand Groups.unusual forecast > 0. The unusual forecast property is calculated as Boolean identifying when
forecast/total orders > Globals.relative forecast. Note: When total orders value is zero, forecast
is considered unusual if the forecast value is greater than zero and is a
historical bucket.
|
| Unusual Forecast B | Alert | Return a count where Base Level.unusual forecast > 0. The unusual forecast property is calculated as a Boolean identifying when
forecast/total orders > Globals.relative forecast max. Note: When total orders value is zero, forecast
is considered unusual if the forecast value is greater than zero and is a
historical bucket.
|
| Unusual Total Orders | Alert | Return a count where Demand Groups.unusual total orders > 0. The unusual total orders property is calculated as Boolean identifying when
total orders/forecast > Globals.relative total order max. Note: When forecast value is zero, total orders
is considered unusual if total orders value is greater than zero and is a
historical bucket.
|
| Unusual Total Orders B | Alert | Return a count where Base Level.unusual total orders > 0. The unusual total orders property is calculated as a Boolean identifying when total orders / forecast > Globals.relative total orders max. Note: If
forecast value is zero, total orders is
considered unusual if total orders value is greater than zero and is a historical
bucket.
|