Cubes#
This section describes the available Critical Manufacturing MES ClickHouse cubes:
| Name | Description |
|---|---|
| Material Movement | Tracks the movement/processing of materials through various steps within it's manufacturing life-cycle, used for calculating Overall Equipment Effectiveness (OEE) and analyzing material losses. |
| WIP View | Latest snapshot of WIP history |
| Product Group Planning and WIP | Assess production performance by comparing product group planning with actual execution. This cube contains indicators limited to the scope of the current fiscal week. |
| Product Group Planning and WIP by Shift | Assess production performance based on product group planning and execution by shift |
| Product Planning and WIP | Assess production performance by comparing product planning with actual execution. This cube contains indicators limited to the scope of the current fiscal week. |
| Product Group Planning and WIP by Shift | Assess production performance based on product planning and execution by shift |
| Resource Maintenance | Detailed tracking and analysis of maintenance operations, allowing insights into maintenance stages, orders, and calendar events over time. |
| Resource States | This cube provides detailed tracking and analysis of resource states, allowing insights into the operational performance, availability, and reliability of equipment over time. |
| Resource States with Non Working Times | Describes the resource states during working and non-working times |
| WIP History | WIP history |
| WIP State Distribution | WIP State Distribution |
Table: Cubes