Skip to content

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.

Example#

MaterialStepCycleTimeDWH