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.
|