---
title: WIP View
alias: business-intelligence-cubes-material-wip
docsync: true
description: "WIP View Cube defines dimensions and measures for tracking work-in-progress inventory"
---

# WIP View Cube

## ClickHouse Cube

* cube_material_wip

## Dimensions

The **WIP View** 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" } |
| **Enterprise Display Order** | Enterprise display order |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Name** | Site name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Display Order** | Site display order |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Name** | Facility name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Display Order** | Facility display order |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Name** | Area name |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Type** | Area type |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Display Order** | Area display order |: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" } |
| **Step Display Order** | Step display order |: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" } |
| **WIP DateTime** | Timestamp when the WIP snapshot was recorded |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: WIP View Dimensions

## Measures

The **WIP View** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **Record Count** | Total number of records in the dataset. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | count |  |
| **Volume In** | Material Quantity that moved in to step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `VolumeIn` |
| **Volume Out** | Material Quantity that moved out of the step |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `VolumeOut` |
| **Queued Primary Quantity** | WIP snapshot in state Queued - total quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_PrimaryQty` |
| **Queued Hold Primary Quantity** | WIP snapshot in state Queued - hold quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Hold_PrimaryQty` |
| **Queued Rework Primary Quantity** | WIP snapshot in state Queued - rework quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Rework_PrimaryQty` |
| **Queued Free Primary Quantity** | WIP snapshot in state Queued - free quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_PrimaryQty - Queued_Hold_PrimaryQty - Queued_Rework_PrimaryQty` |
| **Dispatched Primary Quantity** | WIP snapshot in state Dispatched - total quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Dispatched_PrimaryQty` |
| **Dispatched Hold Primary Quantity** | WIP snapshot in state Dispatched - hold quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Dispatched_Hold_PrimaryQty` |
| **Dispatched Rework Primary Quantity** | WIP snapshot in state Dispatched - rework quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Dispatched_Rework_PrimaryQty` |
| **Dispatched Free Primary Quantity** | WIP snapshot in state Dispatched - free quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Dispatched_PrimaryQty - Dispatched_Hold_PrimaryQty - Dispatched_Rework_PrimaryQty` |
| **In Process Primary Quantity** | WIP snapshot in state In Process - total quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcess_PrimaryQty` |
| **In Process Hold Primary Quantity** | WIP snapshot in state In Process - hold quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcess_Hold_PrimaryQty` |
| **In Process Rework Primary Quantity** | WIP snapshot in state In Process - rework quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcess_Rework_PrimaryQty` |
| **In Process Free Primary Quantity** | WIP snapshot in state In Process - free quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcess_PrimaryQty - InProcess_Hold_PrimaryQty - InProcess_Rework_PrimaryQty` |
| **Processed Primary Quantity** | WIP snapshot in state Processed - total quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Processed_PrimaryQty` |
| **Processed Hold Primary Quantity** | WIP snapshot in state Processed - hold quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Processed_Hold_PrimaryQty` |
| **Processed Rework Primary Quantity** | WIP snapshot in state Processed - rework quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Processed_Rework_PrimaryQty` |
| **Processed Free Primary Quantity** | WIP snapshot in state Processed - free quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Processed_PrimaryQty - Processed_Hold_PrimaryQty - Processed_Rework_PrimaryQty` |
| **In Transit Primary Quantity** | WIP snapshot in state In Transit - total quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InTransit_PrimaryQty` |
| **In Transit Hold Primary Quantity** | WIP snapshot in state In Transit - hold quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InTransit_Hold_PrimaryQty` |
| **In Transit Rework Primary Quantity** | WIP snapshot in state InTransit - rework quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InTransit_Rework_PrimaryQty` |
| **In Transit Free Primary Quantity** | WIP snapshot in state InTransit - free quantity |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InTransit_PrimaryQty - InTransit_Hold_PrimaryQty - InTransit_Rework_PrimaryQty` |
| **All Hold Primary Quantity** | WIP snapshot in all states - all hold count |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Queued_Hold_PrimaryQty + Dispatched_Hold_PrimaryQty + InProcess_Hold_PrimaryQty + Processed_Hold_PrimaryQty + InTransit_Hold_PrimaryQty` |

Table: WIP View 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.