OEE Chart Reports
This module is designed to generate comprehensive OEE Chart Reports using advanced filters and interactive charts. It enables users to analyze Overall Equipment Effectiveness (OEE) and production data with accuracy based on selected criteria.
1. Generate OEE Chart Reportsโ
Step-by-Step User Guideโ
1.1 Access the OEE Chart Report Sectionโ
- Open the main menu
- Navigate to Production and Quality
- Click Reports
- Select Info Graphics โ OEE Charts Reports
1.2 Understanding the Search Fieldsโ
All fields marked with (*) are mandatory.
| Field | Description |
|---|---|
| Date Range | Select the reporting period (Last 7 Days, This Month, Custom) |
| Category | Choose Machine or Operator |
| Part Status | Filter valid production records |
| Report Type | Select the required report using the carousel |
1.3 Field Validationsโ
- All mandatory fields must be selected
- Date Range defaults to the current system date
- Dropdown values are predefined to avoid incorrect input
- If no matching data exists, the system displays No Data Available
1.4 Generate the Reportโ
- Select required filters
- Choose a report from the carousel
- Chart updates automatically
- Hover on the chart to view details
- Click Clear to reset filters
1.5 No Data Found Messageโ
If no data matches the selected filters:
No Data Available
Recommended actions:
- Verify date range
- Check machine or operator selection
- Confirm production data exists for the selected period
2. Common Rules Used Across All Reportsโ
These rules apply to all OEE and Production reports.
2.1 Task Types Consideredโ
Only the following task types are included:
- TK โ Task type
- BLK โ Bulk entry
- HBLK โ Hourly entry
- ASM โ Assembly process
2.2 Part Status Consideredโ
Only valid production records are included:
- APV โ Approved
- CAPRVD โ Conditional Approved
- CRJ โ Casting Rejection
- HI โ Hold for Inspection
- HR โ Hold for Research
2.3 Shift-Based Day Logicโ
All reports use shift-based day calculation.
Production Day = Operate Date + Shift Interval
This ensures correct handling of:
- Night shifts
- Shifts crossing midnight
2.4 Scheduled Maintenance (Idle Time)โ
Idle time is identified dynamically.
Only idle reasons with labelCode = SM are treated as Scheduled Maintenance.
Idle reasons are configuration-driven. No hardcoding is used.
2.5 Control Task Idle Time Reflectionโ
Idle time entered through the Control Task screen is also reflected in the OEE Chart Reports.
- If idle time is added in Control Task, the same idle duration becomes part of the report data for the relevant machine and reporting period.
- If that idle reason is configured with labelCode = SM, it is treated as Scheduled Maintenance Idle Time in OEE calculations.
- If the idle reason uses any other label code, it is still reflected in report calculations that include idle time, but it is not treated as Scheduled Maintenance.
This means Control Task idle entries are reportable in OEE charts, while the idle reason configuration decides how that time is classified in the final calculation.
3. Common Time Definitions (Current)โ
Available Time
- Machine/Day/Month reports: total selected range minutes (24/7 basis), with idle shown separately in breakup tables.
- Operator reports (DMeX): sum of operator shift durations from OperatorShiftLog.
- Operator reports (IoT): sum of operator shift durations from OperatorShiftPlanning.
Production Time
- For machine/day/month reports:
Production = ((Cycle Time + Handle Time) / 60) ร Quantity - For operator production details popup:
- Full Cycle Time = controltask process cycle time
- Operator Split Time = partExecutionSplit time for that operator
- Operator Effective Time = split time if split exists, else full cycle time
PartExecutionSplit logic is applied only in Operator-wise OEE flows (Operator Wise OEE and Operator Wise With Idle Time).
It is not applied to machine/day/month OEE detail popups.
PartExecutionSplit-based operator time is considered only when the linked controltask entry passes valid part-status rules.
For operator split-time:
- Split time is counted only for approved work.
- The linked controltask must be:
- Approved (
APV) or - Conditional Approved (
CAPRVD)
- Approved (
4. Report Formulasโ
Below are the active formulas used in the dashboard.
- Day-wise OEE
- Month-wise OEE
- Machine-wise OEE
- Operator-wise OEE
- Operator OEE with Idle Time
- Operator Efficiency
- Production Reports
Purpose: Daily machine efficiency
- Available = total range minutes for that day
- Idle = scheduled maintenance idle minutes
- Production = cycle-based production time
- OEE (%) = Production รท (Available โ Idle) ร 100
Purpose: Monthly machine efficiency
- Available = total range minutes in selected month range
- Idle = scheduled maintenance idle minutes
- Production = cycle-based production time
- OEE (%) = Production รท (Available โ Idle) ร 100
Purpose: Compare machine efficiency
- Available = total selected range minutes
- Idle = scheduled maintenance idle minutes
- Production = cycle-based production time
- OEE (%) = Production รท (Available โ Idle) ร 100
Purpose: Measure operator productivity
- Available Time = total working time (sum of shifts)
- Production Time = operator effective time
- split time if part split exists
- else full cycle time
- Operator OEE (%) = Production Time รท Available Time ร 100
Purpose: Measure total operator engagement
- Available Time = total working time (sum of shifts)
- Production Time = operator effective time
- Operator OEE with Idle (%) = (Production Time + Idle Time) รท Available Time ร 100
Purpose: Time-based utilization (no quantity)
- Operator Time = Process Cycle Time + Idle Time
- Operator Efficiency (%) = Operator Time รท Operator Available Time ร 100
Production Count
- Production Quantity = Total part produced
Day-wise Production Quantity
- Daily Production Quantity = Total part produced per day
Grafana also shows zero-production days for trend continuity.
5. How to Interpret the Resultsโ
| Observation | Meaning |
|---|---|
| High OEE | Efficient utilization |
| Low OEE | Downtime, maintenance, or low output |
| Operator With Idle OEE > Operator OEE | More idle involvement |
| Zero Production | No execution, maintenance, or no shift |
6. Final Notesโ
If values differ between reports, always verify:
- Which formula family is used: operator vs machine/day/month
- Whether idle time is part of denominator logic
- Whether operator split-time was applied (operator reports only)
All reports are:
- Shift-aware
- Maintenance-aware
- Configuration-driven
- Fully aligned with Grafana
For further assistance, please contact the DMeX Support Team.