Material State Time Distribution DWH#

Description#

This report provides information about how each material spent its time over a period of time.

Facility - Multi value filter on facilities
Area - Multi value filter on Areas (restricted by the Facility filter)
Step - Multi value filter on Steps (restricted by the Facility and Area filters)
Step Type - Multi value filter on Step Types
Product Group - Multi value filter on Product Groups
Product - Multi value filter on Products
Type - Multi value filter on Material Types
Units - Multi value filter on Units
Form - Multi value filter on Material Forms
Shift - Multi value filter on Shifts (restricted by Area)
Date Start - defines the start time threshold filter for material's [State] date and time at a step (date in DWH is set based on the end time of the material's operation which moved the material into the state in a step)
Date End - defines the end time threshold filter for material's [State] date and time at a step (date in DWH is set based on the end time of the material's operation which moved the material into the state in a step)
Expand All Items - true or false

Material.Facility
Material.Area
Material.Step
Material.Product
Material.Type
Material.Form
Material.Units
Time at State [State] - duration in hours of how long a material was at a given state for the period. Aggregation is a simple average, in hours.