---
title: WIP State Distribution
alias: business-intelligence-cubes-wip-state-distribution
docsync: true
description: "A ClickHouse cube for WIP state distribution analysis"
---

# WIP State Distribution Cube

## ClickHouse Cube

* cube_wip_history

## Dimensions

The **WIP State Distribution** Cube has the following dimensions:

| Field | Description | Primary Key | Public |
| --- | ----- | - | - |
| **Enterprise Name** | Company's name. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Name** | Site name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Name** | Facility name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Name** | Area name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Flow Name** | Flow name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Name** | Step name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Type** | Step type |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Name** | Product name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Type** | Product type |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Type** | Material type |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Primary Units** | WIP units |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Name** | Production Order name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Name** | Product family name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Type** | Product family type |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Name** | Calendar name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FY** | Calendar Fiscal Year |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FQ** | Calendar Fiscal Quarter |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FM** | Calendar Fiscal Month |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FW** | Calendar Fiscal Week |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day** | Calendar day |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Shift Name** | Shift name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: WIP State Distribution Dimensions

## Measures

The **WIP State Distribution** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **** |  |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | count |  |
| **Total Wait Time Before Process in seconds** | The Total Wait Time before the Material is Tracked in in a Step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Lag + Dispatched_Lag` |
| **Total Wait Time After Process in seconds** | The Total Wait Time after the Material is Tracked Out in a Step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Processed_Lag` |
| **Total Wait Time in seconds** | The Total Wait Time for the Material in a Step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Lag + Dispatched_Lag + Processed_Lag` |
| **Total Step Cycle Time in seconds** | The Total Material Step Cycle Time |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Lag + Dispatched_Lag + InProcess_Lag + Processed_Lag` |
| **Total In Process Time** | The Total In Process Time for the Material in a Step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcess_Lag` |
| **** |  |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | sum | `Queued_PrimaryQty + Dispatched_PrimaryQty + InProcess_PrimaryQty + Processed_PrimaryQty` |
| **** |  |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | sum | `Queued_PrimaryQty` |
| **** |  |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | sum | `Queued_Rework_PrimaryQty + Dispatched_Rework_PrimaryQty + InProcess_Rework_PrimaryQty + Processed_Rework_PrimaryQty` |
| **** |  |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | sum | `Queued_Hold_PrimaryQty + Dispatched_Hold_PrimaryQty + InProcess_Hold_PrimaryQty + Processed_Hold_PrimaryQty` |
| **Average Total WIP** | Average Total WIP |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `1.0 * {total_wip} / {count}` |
| **Average Queued WIP** | Average Queued WIP |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `1.0 * {queued_wip} / {count}` |
| **Average Rework WIP** | Average Rework WIP |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `1.0 * {rework_wip} / {count}` |
| **Average Hold WIP** | Average Hold WIP |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `1.0 * {hold_wip} / {count}` |

Table: WIP State Distribution Measures

!!! warning "Public Keys"
    All dimensions or measures with the "Public" column marked with a :material-close:{ style="color: #EF5350" } icon must not be used. These are private dimensions/measures, used for intermediate calculations before the aggregations are performed. Using them will result in a query failure.