Skip to content

Material Losses DWH#

Description#

  • This report provides information related to yield (losses)

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
  • 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.Units
  • Material.Facility
  • Material.Area
  • Material.Step
  • Material.Product
  • Material.Type
  • Material.Form
    • «Reason»
    • LossQuantityAbsolute - calculated for a period of time with the sum of all losses (primary quantity only).
    • LossQuantityPercentage - calculated for as the LossQuantityAbsolute divided by the sum of all LossQuantityAbsolute (primary quantity only) over the period of time.

Example#

MaterialLossesDWH