---
title: Material Movement
alias: business-intelligence-cubes-material-movement
docsync: true
description: "This ClickHouse cube provides data for tracking material movement within a manufacturing environment, including quantities, times, and process stages"
---

# Material Movement Cube

## ClickHouse Cube

* cube_material_movement

## Dimensions

The **Material Movement** 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" } |
| **Facility Display Order** | The display order 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-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Display Order** | The display order of the area within the facility. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Name** | The name of the specific manufacturing step where the material entered. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Display Order** | The display order of the specific manufacturing step where the material entered. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Step Type** | The type of the specific manufacturing step where the material entered. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Name** | The name of the material being processed. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Type** | The type of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Form** | The form of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Material Primary Units** | The primary units of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource Name** | The name of the resource (e.g., machine or equipment) involved in processing the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource ResourceType** | The resource user type for the resource. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Date Entered Step** | The ticks for the date and time when the material first entered the step. |:material-check:{ style="color: #4DB6AC" } |:material-close:{ style="color: #EF5350" } |
| **Date Entered Step** | The date and time when the material first entered the step. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **In Process Time** | The date and time when the material first entered the in process state. |:material-close:{ style="color: #EF5350" } |:material-close:{ style="color: #EF5350" } |
| **Processed Time** | The date and time when the material first entered the processed state. |:material-close:{ style="color: #EF5350" } |:material-close:{ style="color: #EF5350" } |
| **Calendar Name** | The name of the calendar used to process the material. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FY** | The calendar fiscal year during which the material is being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FQ** | The calendar fiscal quarter during which the material is being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FM** | The calendar fiscal month during which the material is being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FW** | The calendar fiscal week during which the material is being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day** | The ticks for the calendar day during which the material is being processed. |:material-check:{ style="color: #4DB6AC" } |:material-close:{ style="color: #EF5350" } |
| **Calendar Day** | The calendar day during which the material is being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Shift Name** | The work shift during which the material is being processed. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Name** | The name of the Product of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Type** | The type of the Product of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Name** | The name of the Product Group of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Product Group Type** | The type of the Product Group of the material being processed. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Material Movement Dimensions

## Measures

The **Material Movement** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **Record Count** | Total number of records representing material movements. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | count |  |
| **Queued Primary Quantity** | Total primary quantity of materials queued for processing. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedPrimaryQty` |
| **Queued Secondary Quantity** | Total secondary quantity of materials queued for processing. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedSecondaryQty` |
| **Queued Sub-Materials Primary Quantity** | Total primary quantity of sub-materials queued for processing. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedSubMaterialsPrimaryQty` |
| **Queued Sub-Materials Secondary Quantity** | Total secondary quantity of sub-materials queued for processing. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedSubMaterialsSecondaryQty` |
| **Dispatched Primary Quantity** | Total primary quantity of materials dispatched for the next step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchedPrimaryQty` |
| **Dispatched Secondary Quantity** | Total secondary quantity of materials dispatched for the next step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchedSecondaryQty` |
| **Dispatched Sub-Materials Primary Quantity** | Total primary quantity of sub-materials dispatched for the next step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchedSubMaterialsPrimaryQty` |
| **Dispatched Sub-Materials Secondary Quantity** | Total secondary quantity of sub-materials dispatched for the next step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchedSubMaterialsSecondaryQty` |
| **In Process Primary Quantity** | Total primary quantity of materials currently in process. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcessPrimaryQty` |
| **In Process Secondary Quantity** | Total secondary quantity of materials currently in process. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcessSecondaryQty` |
| **In Process Sub-Materials Primary Quantity** | Total primary quantity of sub-materials currently in process. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcessSubMaterialsPrimaryQty` |
| **In Process Sub-Materials Secondary Quantity** | Total secondary quantity of sub-materials currently in process. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcessSubMaterialsSecondaryQty` |
| **Processed Primary Quantity** | Total primary quantity of materials processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedPrimaryQty` |
| **Processed Secondary Quantity** | Total secondary quantity of materials processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedSecondaryQty` |
| **Processed Sub-Materials Primary Quantity** | Total primary quantity of sub-materials processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedSubMaterialsPrimaryQty` |
| **Processed Sub-Materials Secondary Quantity** | Total secondary quantity of sub-materials processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedSubMaterialsSecondaryQty` |
| **Queued Duration Time** | Total time for materials in the queue. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedLag` |
| **Dispatched Duration Time** | Total time for materials after being dispatched before processing. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchedLag` |
| **In Process Duration Time** | Total time for materials while in process. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `InProcessLag` |
| **Processed Duration Time** | Total time for materials after being processed. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedLag` |
| **Cycle Time** | Cycle time for the materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `QueuedLag + DispatchedLag + InProcessLag + ProcessedLag` |
| **Average Cycle Time** | Average cycle time for the materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | avg | `QueuedLag + DispatchedLag + InProcessLag + ProcessedLag` |
| **Minimum cycle Time** | Minimum cycle time for the materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | min | `QueuedLag + DispatchedLag + InProcessLag + ProcessedLag` |
| **Maximum cycle Time** | Maximum cycle time for the materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | max | `QueuedLag + DispatchedLag + InProcessLag + ProcessedLag` |
| **Dispatch Count** | Total number of dispatches for materials to the next step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `DispatchCount` |
| **Track-In Count** | Total number of times materials were tracked into the step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `TrackInCount` |
| **Track-Out Count** | Total number of times materials were tracked out of the step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `TrackOutCount` |
| **Abort Process Count** | Total number of aborts during material processing in a given Step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `AbortProcessCount` |
| **Rework Count** | Total number of reworks performed on materials in a given Step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ReworkCount` |
| **Terminated Process Count** | Total number of terminated operations in a given Step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `TerminatedCount` |
| **Step Output Primary Quantity** | Total primary output quantity of materials from a step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `StepOutputPrimaryQty` |
| **Step Output Secondary Quantity** | The total secondary quantity of materials output from a step. This represents one of the two quantities that translate to each other for the material. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `StepOutputSecondaryQty` |
| **Step Output Sub-Materials Primary Quantity** | The total primary quantity of sub-materials output from a step. This represents one of the two quantities that translate to each other for the sub-material. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `StepOutputSubMaterialsPrimaryQty` |
| **Step Output Sub-Materials Secondary Quantity** | The total secondary quantity of sub-materials output from a step. This represents one of the two quantities that translate to each other for the sub-material. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `StepOutputSubMaterialsSecondaryQty` |
| **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" } | sum | `Material_Primary_Quantity_Losses` |
| **Secondary Quantity Losses** | The total secondary 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" } | sum | `Material_Secondary_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` |
| **Total Primary Quantity Losses** | The total primary quantity of material and sub-material losses. This represents the amount of material lost during the processing steps. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Material_Primary_Quantity_Losses + Material_SubMaterials_Primary_Quantity_Losses` |
| **Step Output Total Primary Quantity** | Total primary output quantity of materials and sub-materials from a step. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `StepOutputPrimaryQty + StepOutputSubMaterialsPrimaryQty` |
| **Total Processed Primary Quantity** | Total processed primary quantity of materials and sub-materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `ProcessedPrimaryQty + ProcessedSubMaterialsPrimaryQty` |
| **Rate Of Quality** | The Rate of Quality for the period - one of the components of Overall Equipment Effectiveness (OEE), calculated as the percentage of processed primary quantity relative to the total of processed primary quantity and primary quantity losses. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_rate_of_quality} * 100.0` |
| **_Rate Of Quality** | Internal Use - The Rate of Quality for the period - one of the components of Overall Equipment Effectiveness (OEE), calculated as the percentage of processed primary quantity relative to the total of processed primary quantity and primary quantity losses. |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `CASE   WHEN ({total_processed_primary_quantity} + {total_primary_quantity_losses}) != 0   THEN {total_processed_primary_quantity}/({total_processed_primary_quantity} + {total_primary_quantity_losses})   ELSE 0 END` |
| **Ideal Cycle Time** | The ideal cycle time for processing materials. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `multiplyDecimal(Material_IdealCycleTime, (ProcessedPrimaryQty + ProcessedSubMaterialsPrimaryQty))` |

Table: Material Movement 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.