---
title: Product Group Planning and WIP by Shift
alias: business-intelligence-cubes-product-group-plan-wip-shifts
docsync: true
description: "This documentation details the Product Group Planning and WIP by Shift Cube, defining its dimensions and measures for analyzing planned and actual production volumes by shift"
---

# Product Group Planning and WIP by Shift Cube

## ClickHouse Cube

* cube_product_group_plans_wip_shifts

## Dimensions

The **Product Group Planning and WIP by Shift** 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" } |
| **Calendar Name** | The specific calendar name associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar FY** | The calendar fiscal year associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar FQ** | The calendar fiscal quarter associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar FM** | The calendar fiscal month associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar FW** | The calendar fiscal week associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day** | The specific calendar day associated with the plan. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Name** | Product Group used as Plan Item defined in terms of the production item. |: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" } |
| **Plan TimeUnit** | Plan's Time Unit |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Plan Name** | Plan name. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Shift Name** | Shift name. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Plan TimeValue** | The Time associated with the plan depending on the Plan's Time Unit |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Product Group Planning and WIP by Shift Dimensions

## Measures

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

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **Shift Plan** | Forecasted production volumes for each product. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | min | `Shift_Plan` |
| **Shift Volume** | Material Quantity that moved out of the step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Shift_Volume` |

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