---
alias: user-guide-material-state-time-distribution
tags:
- reports
description: "This report analyzes material time distribution data within a database, using various filters"
---

# Material State Time Distribution DWH

## Description

* This report provides information about how each material spent its time over a period of time.

## Data Source

* 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 [State] 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 [State] 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.Facility**
* **Material.Area**
* **Material.Step**
* **Material.Product**
* **Material.Type**
* **Material.Form**
* **Material.Units**
* **Time at State [State]** - duration in hours of how long a material was at a given state for the period. Aggregation is a simple average, in hours.

## Example

![Screenshot showing a diagram illustrating the material state time distribution, including various process and probe types.](../images/MaterialStateTimeDistributionDWH.png)