Material Facility Cycle Time DWH#
Description#
This report provides information related to Facility cycle time - how long does it take to process a Material at a Facility.
Data Source(s)#
- DWH Database
Assumptions#
- Calendar Days must have been generated for the Calendars of the relevant Areas
Filters#
- 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
- Date Start - defines the start time threshold filter for material facts (date in DWH is set based on the end time of the material's operation, e.g. Split, Merge, Assemble, etc)
- Date End - defines the end time threshold filter for material facts (date in DWH is set based on the end time of the material's operation, e.g. Split, Merge, Assemble, etc)
- Expand All Items - true or false
Fields#
- Material.Facility
- Material.Area
- Material.Step
- Material.Product
- Material.Type
- Material.Form
- Material.Units
Values#
- Facility Cycle Time - Material time at a Facility. Only count materials which have been Shipped during the period - use timestamp of Material when it left the facility minus the Material DateEnteredFacility property. The aggregation is performed by weighting the quantity [sum (time x quantity) / sum quantity)]
Example#
