Skip to content

Material Pass Test Results DWH#

Description#

This report provides information related to Material Defects detected at a Resource, by providing the First Pass Test and First Pass Yield.

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)
  • FlowPath - Multi value filter on Flow Paths
  • Production Order - Multi value filter on Production Orders
  • 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 Definition - Multi value filter on Shift Definitions
  • Shift - Multi value filter on Shifts
  • 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)
  • Calculation Type - Material or Parent Material
  • Show Yield - true or false
  • Show Second Pass Info - true or false
  • Show Third Pass Info - true or false
  • Show Chart - true or false
  • Limit Top Reasons in Chart - default is NULL
  • Expand All Items - true or false

Fields#

  • Material.Facility
  • Material.Area
  • Material.Step
  • Material.Product
  • Material.Resource
  • Material.ProcessResource
  • Material.FlowPath

Values#

  • First Pass Test - It represents the ratio of quantity that passed a test in a certain process, for the first passage in a process (FlowPath). The first passage is determined by the absence of any Material Defects during the processing of the Material in a process (FlowPath); the test being passed is determined by no Material Defects having been open during the process.
  • First Pass Yield - It represents the ratio of good pieces (any quantity that is not lost, repaired or has a confirmed defect) coming out of a process, for the first passage in a process (FlowPath). The first passage is determined by the absence of any Material Defects during the processing of the Material in a process (FlowPath); the test being passed is determined by no Material Defects having been open during the process.
  • Second Pass Test - It represents the ratio of quantity that passed a test in a certain process, for the second passage in a process (FlowPath). The second passage is determined by the presence of a Material Defect with Sequence 1, meaning that the Material had previously, one time, failed a test in that process (FlowPath).
  • Second Pass Yield - It represents the ratio of good pieces (any quantity that is not lost, repaired or has a confirmed defect) coming out of a process, for the second passage in a process (FlowPath). The second passage is determined by the presence of a Material Defect with Sequence 1, meaning that the Material had previously, one time, failed a test in that process (FlowPath).
  • Third Pass Test - It represents the ratio of quantity that passed a test in a certain process, for the third passage in a process (FlowPath). The Third passage is determined by the presence of a Material Defect with Sequence 2, meaning that the Material had previously, two times, failed a test in that process (FlowPath).
  • Third Pass Yield - It represents the ratio of good pieces (any quantity that is not lost, repaired or has a confirmed defect) coming out of a process, for the third passage in a process (FlowPath). The third passage is determined by the presence of a Material Defect with Sequence 2, meaning that the Material had previously, one time, failed a test in that process (FlowPath).

Example#

MaterialFirstPass