---
title: Product Planning and WIP
alias: business-intelligence-cubes-product-plan-wip
docsync: true
description: "A Product Planning and WIP Cube organizes production data by enterprise, site, and product details"
---

# Product Planning and WIP Cube

## ClickHouse Cube

* cube_product_plans_wip

## Dimensions

The **Product Planning and WIP** Cube has the following dimensions:

| Field | Description | Primary Key | Public |
| --- | ----- | - | - |
| **Enterprise Name** | The name of the enterprise or company. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Name** | The name of a specific site or location. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Name** | The name of the facility within the site. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Name** | The name of the area within the facility. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Display Order** | The Area's order within the process flow. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Name** | Product used as Plan Item defined in terms of the production item. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Type** | Product's type. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Name** | Steps used on the planning. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Display Order** | The Step's order within the process flow. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Plan Level** | To view information organized by Product or Product Group. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Type** | Material's type. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Plan Name** | Plan name. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Product Planning and WIP Dimensions

## Measures

The **Product Planning and WIP** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **Daily Plan** | Forecasted production volumes for each product. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Daily_Plan` |
| **Daily Volume** | Material Quantity that moved out of the step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Daily_Volume` |
| **Total WIP** | Current instant total WIP. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Total_WIP` |
| **Total Hold** | Current wip on hold. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Total_Hold` |
| **Total Free WIP** | Current wip excluding hold status. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Total_Free_WIP` |
| **Total_Rework** | Current wip in rework. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Total_Rework` |
| **Processed Primary Quantity** | Processed primary quantity of materials processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Processed_Primary_Quantity` |
| **Primary Quantity Losses** | The total primary quantity of material losses. This represents the amount of material lost during the processing steps. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Primary_Quantity_Losses` |
| **Yield** | The percentage yield of processed materials relative to the total quantity of materials input, accounting for primary quantity losses. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `CASE   WHEN ({processed_primary_quantity} + {primary_quantity_losses}) > 0   THEN {processed_primary_quantity}/({processed_primary_quantity} + {primary_quantity_losses}) * 100.0   ELSE 0 END` |
| **Week To Date** | Cumulative volume from the beginning or the fiscal week until the present day. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Wtd` |
| **Week To Date Plan** | Planned Volume from the beginning of the fiscal week of the present day. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `wP` |
| **Time to completion** | Simple estimation (little's law) to determine time expected to finish current WIP by step, in minutes. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `Time_To_Completion` |

Table: Product Planning and WIP 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.