---
alias: user-guide-material-losses
tags:
- reports
description: "This report analyzes material losses within a data warehouse, utilizing configurable filters"
---

# 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][MaterialLossesDWH]

[MaterialLossesDWH]: ../images/MaterialLossesDWH.png