---
alias: user-guide-material-facility-cycle-time
tags:
- reports
description: "This report analyzes material processing times within facilities using a data warehouse"
---

# Material Facility Cycle Time DWH

## Description

This report provides information related to Facility cycle time - how long does it take to process a Material at a Facility.

## 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
* **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)
* **Expand All Items** - true or false

## Fields

* **Material.Facility**
* **Material.Area**
* **Material.Step**
* **Material.Product**
* **Material.Type**
* **Material.Form**
* **Material.Units**

## Values

* **Facility Cycle Time** - Material time at a Facility. Only count materials which have been Shipped during the period - use timestamp of Material when it left the facility minus the Material DateEnteredFacility property. The aggregation is performed by weighting the quantity [sum (time x quantity) / sum quantity)]

## Example

![MaterialFacilityCycleTimeDWH][MaterialFacilityCycleTimeDWH]

[MaterialFacilityCycleTimeDWH]: ../images/MaterialFacilityCycleTimeDWH.png