---
title: Material Loss & Bonus
alias: business-intelligence-cubes-material-loss-bonus
search:
  boost: 4
docsync: true
---

# Material Loss & Bonus Cube

## ClickHouse Cube

* cube_material_loss_bonus

## Dimensions

The **Material Loss & Bonus** 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 name of the specific manufacturing step where the event occurred. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Name** | The name of the material being processed. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Change Type** | Classification of the change (e.g., Loss, Bonus). |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Change Reason** | The specific reason code for the material loss or bonus. |: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" } |
| **Product Name** | The name of the Product associated with the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Name** | The name of the Product Group. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Type** | The type of the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Form** | The form of the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource Name** | The name of the resource or equipment where the loss/bonus was registered. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Change Primary Units** | The unit of measure for the primary quantity change. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Material Loss & Bonus Dimensions

## Measures

The **Material Loss & Bonus** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Format | Formula |
| ---- | ------------ | - | - | - | - | ---- |
| **Record Count** | Total number of loss/bonus transaction records. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | count |  |  |
| **Change Primary Quantity** | The total primary quantity of material loss or bonus. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Change_PrimaryQty` |
| **Change Secondary Quantity** | The total secondary quantity of material loss or bonus. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Change_SecondaryQty` |
| **Total Loss Primary Quantity** | Total primary quantity filtered explicitly for 'Loss' events. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Change_PrimaryQty` |
| **Total Bonus Primary Quantity** | Total primary quantity filtered explicitly for 'Bonus' events. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Change_PrimaryQty` |
| **Context Material Primary Quantity** | The primary quantity of the material at the time of the event. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Material_PrimaryQty` |
| **Context Rework Count** | The rework count of the material at the time of the event. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Material_ReworkCount` |
| **Context Hold Count** | The hold count of the material at the time of the event. |:material-check:{ style="color: #4DB6AC" } | :material-check:{ style="color: #4DB6AC" } | sum |  | `Material_HoldCount` |

Table: Material Loss & Bonus 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.