Resource OEE History#
Overview#
The Resource OEE History dashboard provides a comprehensive view of the historical performance of Resources using the Overall Equipment Effectiveness (OEE) metric.
Folder#
- Performance
Database#
- DWH (queried via Cube using GraphQL)
Data#
- OEE (%)
- Availability (%)
- Quality (%)
- Performance (%)
- Rate Efficiency
- Operational Efficiency (%)
Example#
Data Breakdown#
| KPI | Description | Formula | Datasource |
|---|---|---|---|
| OEE | Measures equipment effectiveness based on Availability, Performance, and Quality. | Availability x Performance x Quality | resource_states_non_working_times in Resource Cube |
| Availability | Indicates how much of the scheduled production time a Resource was operating, excluding downtime. | Operating Time ÷ Potential Production Time x 100 | resource_states_non_working_times in Resource Cube |
| Quality | Measures the percentage of good (non-defective) units produced compared to the total units processed. | Total Processed Primary Quantity ÷ (Total Processed Primary Quantity + Total Primary Quantity Losses) x 100 | material_movement in Material Cube |
| Performance | Measures how efficiently a Resource operates by comparing the actual operating speed to its ideal cycle time during productive time. | Ideal Cycle Time ÷ Operating Time x 100 | resource_states_non_working_times in Resource Cube |
| Rate Efficiency | Indicates the efficiency of the operating speed of a Resource compared to its ideal rate during the period. | Ideal Cycle Time ÷ Net Operating Time x 100 | resource_states_non_working_times in Resource Cube |
| Operational Efficiency | Measures the proportion of actual productive time a Resource uses compared to total operating time available, excluding planned and unplanned downtime. | Net Operating Time ÷ Operating Time x 100 | resource_states_non_working_times in Resource Cube |
Data Visualization#
| Panel | Description | Threshold Values | Datasource |
|---|---|---|---|
| OEE overtime | Time Series displaying the evolution of Availability, Performance, Quality, and OEE across the selected time period. | N/A | resource_states_non_working_times in Resource Cube and material_movement in Material Cube |
| OEE components | Circular Bar Chart displaying KPIs: OEE, Availability, Performance, and Quality. | N/A | resource_states_non_working_times in Resource Cube and material_movement in Material Cube |
| Performance components | Circular Bar Chart displaying KPIs: Performance, Rate Efficiency, and Operational Efficiency. | N/A | resource_states_non_working_times in Resource Cube |
| Resource OEE History | Table showing historical OEE values | Colors representing ranges: red (0–70%), yellow (70–100%), green (100%) | resource_states_non_working_times in Resource Cube |
Entity Filters#
Single selection#
- Enterprise
- Site
Multiple/All selection#
- Facility
- Area
- Resource
- Shift
- Model
- Resource 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.