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. | ||
| Site Name | The name of the specific site. | ||
| Facility Name | The name of the facility within the site. | ||
| Area Name | The name of the area within the facility. | ||
| Step Name | The name of the specific manufacturing step where the event occurred. | ||
| Material Name | The name of the material being processed. | ||
| Change Type | Classification of the change (e.g., Loss, Bonus). | ||
| Change Reason | The specific reason code for the material loss or bonus. | ||
| Calendar Day Ticks | The ticks for the calendar day of the event. | ||
| Calendar Day | The calendar day during which the event occurred. | ||
| Calendar Day FY | The calendar fiscal year. | ||
| Calendar Day FQ | The calendar fiscal quarter. | ||
| Calendar Day FM | The calendar fiscal month. | ||
| Calendar Day FW | The calendar fiscal week. | ||
| Shift Name | The work shift during which the event occurred. | ||
| Product Name | The name of the Product associated with the material. | ||
| Product Group Name | The name of the Product Group. | ||
| Material Type | The type of the material. | ||
| Material Form | The form of the material. | ||
| Resource Name | The name of the resource or equipment where the loss/bonus was registered. | ||
| Change Primary Units | The unit of measure for the primary quantity change. |
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. | count | ||||
| Change Primary Quantity | The total primary quantity of material loss or bonus. | sum | Change_PrimaryQty | |||
| Change Secondary Quantity | The total secondary quantity of material loss or bonus. | sum | Change_SecondaryQty | |||
| Total Loss Primary Quantity | Total primary quantity filtered explicitly for 'Loss' events. | sum | Change_PrimaryQty | |||
| Total Bonus Primary Quantity | Total primary quantity filtered explicitly for 'Bonus' events. | sum | Change_PrimaryQty | |||
| Context Material Primary Quantity | The primary quantity of the material at the time of the event. | sum | Material_PrimaryQty | |||
| Context Rework Count | The rework count of the material at the time of the event. | sum | Material_ReworkCount | |||
| Context Hold Count | The hold count of the material at the time of the event. | sum | Material_HoldCount |
Table: Material Loss & Bonus Measures
Public Keys
All dimensions or measures with the "Public" column marked with a 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.