Step Overview#
Overview#
The Step Overview dashboard provides performance and loss analysis for a specific production step. It helps identifying inefficiencies, frequent failure causes, and correlations between yield and cycle performance.
Folder#
Performance folder.
Database#
- CDM (queried via OData).
- DWH (queried via Cube using GraphQL).
Data#
- Yield
- Loss
- Unit Cycle Time (UCT)
Example#
Data Breakdown#
| KPI | Description | Formula | Datasource |
|---|---|---|---|
| Yield (%) | Share of processed material that becomes usable output for the current step. | (Good units ÷ Total units) × 100 | material_movement from Material Cube |
| Loss | Material losses grouped by reasons or product group and ranked by absolute loss quantity. | Sum of loss (Change_PrimaryQty) grouped by reason or product group. | MaterialLossBonus table in MaterialLossBonus |
| Unit Cycle Time | Average processing time per unit of material in the step. | Time the material was in the process / Processed quantity (Sum(In-Process Duration) ÷ Sum(Processed Quantity)). | material_movement.in_process_duration and material_movement.processed_primary_quantity from Material Cube |
Data Visualization#
| Panel | Description | Threshold Values | Datasource |
|---|---|---|---|
| Yield | KPI card displaying the yield value for the current step and filters. | Red <80%, Yellow 80–90%, Green >90%. | material_movement in Material Cube |
| Unit Cycle Time | KPI card showing average unit processing time at the step. | As low as possible. | material_movement from Material Cube |
| Top Loss Reasons | Bar chart showing top loss reasons. | Highest loss reason highlighted in red. | MaterialLossBonus table in MaterialLossBonus |
| Losses Over Time by Product Group | Line chart of losses by product group over time. If no product groups are in use, it will display losses grouped in a single "no product group" line. You can also select which product groups to see. | Higher lines represent greater losses. | MaterialLossBonus table in MaterialLossBonus |
| Yield and UCT Correlation Analysis | Dual-axis time series comparing yield (%) and UCT (s/unit). | Yield should be high, UCT should be low. | material_movement from Material Cube |
Filters and Settings#
Single selection:
- Enterprise
- Site
- Step
- Material Units
- Show Top (10, 20, 50, 100)- pertains to how many materials and reasons are presented in the graphs.
Multiple/All selection:
- Facility
- Area
- Product Group
- Product Type
- Product
- Step Type
Time/Date Filter#
The system provides a time/date filter with an Absolute time range option and a list of quick ranges, which you can apply as shown in the image below.
Date Filter Options#
- Changing Time Zone
- Changing Fiscal Year
Refresh Button Options#
The system provides a Refresh button with various options to select.