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.