---
alias: user-guide-material-step-cycle-time
tags:
- reports
description: "This report analyzes material step cycle times within a data warehouse environment"
---

# Material Step Cycle Time DWH

## Description

* This report provides information related to Step cycle time - how long does it take for a Material to go through a Step.

## 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 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.Facility**
* **Material.Area**
* **Material.Step**
* **Material.Product**
* **Material.Type**
* **Material.Form**
* **Material.Units**
* **Material Step Cycle Time** - Material time at a Step. Only count materials which have been Moved Next, Special Moved Next, Changed Material Flow And Step (in the case that the Step was changed), Reworked or Received during the period - use timestamp when Material was moved out of the step minus the Material DateEnteredStep property. The aggregation is performed by weighting the quantity [sum (time x quantity)/(sum quantity)]. The quantity considered here is Processed. However, with Pass-Through Steps, the quantity that is considered is Queued.

## Example

![MaterialStepCycleTimeDWH][MaterialStepCycleTimeDWH]

[MaterialStepCycleTimeDWH]: ../images/MaterialStepCycleTimeDWH.png