---
alias: user-guide-material-pass-test
tags:
- reports
description: "This report analyzes material test results, tracking pass rates and identifying defect sequences within production processes"
---

# 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](../images/MaterialPassTest.png)