---
title: Material Hold & Release
alias: business-intelligence-cubes-material-hold-release
search:
  boost: 4
docsync: true
---

# Material Hold & Release Cube

## ClickHouse Cube

* cube_material_hold_release

## Dimensions

The **Material Hold & Release** Cube has the following dimensions:

| Field | Description | Primary Key | Public |
| --- | ----- | - | - |
| **Enterprise Name** | The name of the enterprise or company. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Name** | The name of the specific site. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Name** | The name of the facility within the site. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Name** | The name of the area within the facility. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Name** | The manufacturing step where the hold/release occurred. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Name** | The name of the material placed on hold or released. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Name** | The name of the Product associated with the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Action** | The type of action taken: e.g., 'Hold' or 'Release'. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Reason** | The specific reason code for the Hold or Release. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day Ticks** | The ticks for the calendar day of the event. |:material-check:{ style="color: #4DB6AC" } |:material-close:{ style="color: #EF5350" } |
| **Calendar Day** | The calendar day during which the event occurred. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FY** | The calendar fiscal year. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FQ** | The calendar fiscal quarter. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FM** | The calendar fiscal month. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FW** | The calendar fiscal week. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Shift Name** | The work shift during which the event occurred. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Material Hold & Release Dimensions

## Measures

The **Material Hold & Release** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Format | Formula |
| ---- | ------------ | - | - | - | - | ---- |
| **Total Events** | Total number of Hold and Release events. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | count |  |  |
| **Total Holds** | Total number of materials placed on hold. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | count |  |  |
| **Total Releases** | Total number of materials released from hold. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | count |  |  |

Table: Material Hold & Release 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.