Material Step Cycle Time DWH#
Description#
- This report provides information related to Step cycle time - how long does it take for a Material to go through a Step.
Data Source#
- 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
- Shift - Multi value filter on Shifts (restricted by Area)
- Date Start - defines the start time threshold filter for material's queued 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 queued 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
Fields#
- Material.Facility
- Material.Area
- Material.Step
- Material.Product
- Material.Type
- Material.Form
- Material.Units
- Material Step Cycle Time - Material time at a Step. Only count materials which have been Moved Next, Special Moved Next, Changed Material Flow And Step (in the case that the Step was changed), Reworked or Received during the period - use timestamp when Material was moved out of the step minus the Material DateEnteredStep property. The aggregation is performed by weighting the quantity [sum (time x quantity)/(sum quantity)]. The quantity considered here is Processed. However, with Pass-Through Steps, the quantity that is considered is Queued.