Material Yield Loss DWH#

Description#

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

Material.Units
Material.Facility
Material.Area
Material.Step
Material.Product
Material.Type
Material.Form
Loss Quantity Absolute - is calculated for a period of time with the sum of all losses minus the sum of all bonuses, that is, the Material TrackIn Primary Quantity minus the current Material Primary Quantity at TrackOut. Note that it can be negative in case of bonuses. The aggregation of Loss Quantity Absolute is a simple sum.
Yield Loss (%) - can be calculated as the LossQuantityAbsolute divided by the QuantityProcessed over a period of time, that is, the (Material TrackInQuantity - Material Quantity)/(Material TrackInQuantity) at TrackOut. If Material TrackInQuantity is zero, the YieldLossPercentage is zero. The aggregation of YieldLossPercentage is equal to [SUM(Material TrackInQuantity) - SUM (Material Quantity)]/SUM(Material TrackInQuantity) at TrackOut. Again, if SUM(Material TrackInQuantity ) is zero, the Yield Loss Percentage is equal to zero.