ISO Data and Analytics (OEE / RAM / EMS)
Table of Contents
- Overview
- Screen Layout
- Top — Search Area
- Left — Model (Asset Tree) Panel
- Right — Analytics Content (3 Tabs)
- Metric Definitions
- Usage Scenarios
- Frequently Asked Questions
- Related Screens
Overview
Menu location Left menu ISO > ISO Data / ISO Analytics
The ISO Data and Analytics screen lets you analyze three ISO 22400-based operational performance metrics with charts and tables on a single screen.
| Plugin | Name | Meaning of Abbreviation |
|---|---|---|
| OEE | Overall equipment effectiveness | Overall Equipment Effectiveness |
| RAM | Reliability·Maintainability | Reliability·Availability·Maintainability |
| EMS | Energy management | Energy Management System |
All three plugins share the same left-hand asset tree and search area; only the right-hand content changes, showing different charts and tables depending on the tab.
Path: Left menu > ISO > ISO Data (internal URL /asset/plugin/index) or ISO > ISO Analytics (internal URL /analysis/index)
Screen Layout
┌──────────────────────────────────────────────────────────────────────┐
│ 🌎 ISO 데이터 [기간 ▭▭▭] [플러그인 ▼] [건수 ▼] [조회][전체출력][↻]│ ← ① 상단
├──────────┬───────────────────────────────────────────────────────────┤
│ 🗂 모델 │ ◯ 추이 차트 (OEE/RAM/EMS 중 선택된 탭) │
│ ─────── │ ┌──────────────────────────────────────────────────────┐ │
│ 사이트▼ │ │ 라인/영역 차트 토글, 300px 높이 │ │ ← ②/③
│ ─────── │ └──────────────────────────────────────────────────────┘ │
│ 🔍 검색 │ │
│ ─────── │ ◯ 히스토리 테이블 (탭별 컬럼 다름) │
│ 에셋 │ ┌──────────────────────────────────────────────────────┐ │
│ 트리 │ │ 시간 / 워크오더 / 핵심 지표 컬럼들 │ │
│ ─────── │ └──────────────────────────────────────────────────────┘ │
│ 오브젝트│ │
│ ID : │ │
└──────────┴───────────────────────────────────────────────────────────┘
| Area | Position | Contents |
|---|---|---|
| ① Top | Full width | Search area (period, plugin, record count, tools) |
| ② Left | col-lg-2 | Site selector + asset tree |
| ③ Right | col-lg-10 | Trend chart + history table (selected plugin tab) |
Top — Search Area
🌎 ISO 데이터 [기간] [플러그인 ▼] [건수 ▼] [조회] [전체 출력] [↻]
| Control | Width | Description |
|---|---|---|
Period (search_time) | 280px | Start–end date/time (center-aligned, bold). Date range picker |
Plugin (plugin_type) | 200px | Select OEE/RAM/EMS — on change (onPluginTypeChange()), the right-hand content tab switches automatically |
Record count (filter_limit) | 150px | Latest 1,000 (default)/5,000/10,000 records |
| Query | Red + 🔍 | search() — Queries data for the asset selected in the left tree using the conditions above |
| Export all | Red + 📄 | downloadCSV() — Downloads the full result set for the search conditions as CSV |
| Refresh | Red + ↻ | refresh() — Refreshes the screen |
Plugin Selector Options
| Value | Label |
|---|---|
OEE | OEE - Overall Equipment Effectiveness |
RAM | RAM - Reliability/Maintainability |
EMS | EMS - Energy Management |
Left — Model (Asset Tree) Panel
A tree panel with the same structure as Data Point.
| Area | Contents |
|---|---|
| 3 header tools | Show description toggle (btn_show_description) / Search toggle (searchItem()) / Copy selection (copySelectedTags()) |
Site selector (site_select) | Site name [description] options. Changing it reloads the tree |
Asset tree (assetTreeDiv) | Site → Area → Line → Equipment → tag hierarchy |
| Search input | Toggle-based (assetSearchInput) — placeholder: "Search..." |
| Footer | ID preview of the hovered asset (tag_hover) |
You must select an equipment-level node in the asset tree for data to appear in the chart and table on the right. If no equipment is selected, the chart area displays the message "Select equipment in the asset tree and run a query."
Right — Analytics Content (3 Tabs)
The right-hand content area switches automatically according to the plugin selector value.
| Selector Value | Displayed div |
|---|---|
OEE (default) | tab_oee |
RAM | tab_ram |
EMS | tab_ems |
Each tab consists of two panels: a trend chart (top) and a history table (bottom).
OEE Tab
Trend Chart — oee_trend_chart (300px)
| Item | Description |
|---|---|
| Header | 📈 "OEE Trend" + result summary (result_txt) |
| Chart type toggle | Line (default) ↔ Area (changeChartType('oee','line'/'area')) |
| Series | OEE / Availability / Performance / Quality (4 series) |
| Empty state | "Select equipment in the asset tree and run a query." |
History Table — oee_data_table (12 columns)
| Column | Width | Description |
|---|---|---|
| Time | 120px | Measurement time |
| Work order | 150px | ID of the work order in progress during that period |
| Equipment status | 70px | RUN/STOP/IDLE, etc. |
| Total | 60px | Total production quantity |
| Good | 60px | Number of good units |
| Defective | 60px | Number of defective units |
| Uptime | 80px | Unit time (minutes/hours) |
| Downtime | 80px | Non-operating time |
| OEE | 55px | Overall effectiveness (%) — Availability × Performance × Quality |
| Availability | 55px | Availability (%) |
| Performance | 55px | Performance (%) |
| Quality | 55px | Quality (%) |
RAM Tab
Trend Chart — ram_chart (300px)
| Item | Description |
|---|---|
| Header | 📈 "RAM Trend" |
| Chart type toggle | Line (default) ↔ Area |
| Series | MTBF · MTTR · MA · R · M (5 series) |
History Table — ram_data_table (9 columns)
| Column | Width | Description |
|---|---|---|
| Time | 120px | Measurement time |
| Work order | 150px | Work order ID |
| MTBF(h) | 70px | Mean Time Between Failures (hours) |
| MTTR(h) | 70px | Mean Time To Repair (hours) |
| MA(%) | 60px | Maintainability Availability |
| Failure rate | 70px | Failure Rate (probability of failure per unit time) |
| R(1h) | 60px | 1-hour reliability |
| M(1h) | 60px | 1-hour maintainability |
| Failure count | 60px | Cumulative number of failures |
EMS Tab
Trend Chart — ems_chart (300px)
| Item | Description |
|---|---|
| Header | 📈 "EMS Trend" |
| Chart type toggle | Line (default) ↔ Area |
| Series | Energy consumption / Efficiency / CO2 emissions / Peak and average power |
History Table — ems_data_table (10 columns)
| Column | Width | Description |
|---|---|---|
| Time | 120px | Measurement time |
| Work order | 150px | Work order ID |
| Energy(kWh) | 80px | Total power consumption in that interval |
| Per unit(kWh) | 80px | Power consumption per one unit of the work order's unit — written with the denominator unit (e.g. 0.34 kWh/EA, 0.34 kWh/kg). Work orders with different units are not compared directly |
| Efficiency(%) | 60px | Energy efficiency |
| CO2(kg) | 70px | Total CO2 emissions in that interval |
| Scope1(kg) | 75px | Direct emissions (on-site fuel combustion, etc.) |
| Scope2(kg) | 75px | Indirect emissions (purchased electricity, etc.) |
| Peak(kW) | 70px | Maximum instantaneous power in that interval |
| Average(kW) | 70px | Average power in that interval |
Metric Definitions
The Three Components of OEE
| Metric | Calculation | Meaning |
|---|---|---|
| Availability | Uptime ÷ Planned operating time | Ratio of actual uptime to the time the equipment should have been running |
| Performance | Actual output ÷ Ideal output | Actual throughput rate versus the ideal during uptime |
| Quality | Good units ÷ Total output | Proportion of good units in total production |
| OEE | Availability × Performance × Quality | Overall effectiveness (100% when all three metrics are 100%) |
Key RAM Metrics
| Metric | Calculation | Unit | Meaning |
|---|---|---|---|
| MTBF | Total uptime ÷ Number of failures | Hours (h) | Mean time between failures — higher means better reliability |
| MTTR | Total repair time ÷ Number of failures | Hours (h) | Mean repair time — lower means better maintainability |
| MA | MTBF ÷ (MTBF + MTTR) | % | Availability |
| R(t) | exp(-λt) | Ratio | Probability of running without failure over time t (λ = failure rate) |
| M(t) | 1 − exp(-μt) | Ratio | Probability that repair is completed within time t (μ = repair rate) |
EMS Emission Categories
| Category | Meaning |
|---|---|
| Scope 1 | Generated directly at the site (combustion of fuel in owned boilers, generators, vehicles) |
| Scope 2 | Indirect emissions from purchased electricity, heat, or steam |
| Scope 3 | (Not shown on this screen) The entire value chain including supply chain, transport, and disposal — calculated in a separate report |
Usage Scenarios
| Scenario | Screen | Procedure |
|---|---|---|
| Weekly line OEE trend | OEE tab | Period 7 days, plugin OEE → select line asset → Query → compare the 4 series in the trend chart |
| Downtime root cause analysis | OEE history | Click a row for a period with low OEE → check the work order ID → cross-analyze with Work Orders |
| Determining maintenance intervals (MTBF) | RAM tab | Check the average MTBF per asset in the RAM history → set the maintenance interval to about 1/3 of the MTBF |
| Comparing new vs. aging equipment | RAM | Compare MTBF, MTTR, and failure counts of two assets over the same period |
| Energy saving KPI | EMS tab | Analyze the per-unit (kWh) trend → compare by work order → identify low-efficiency intervals |
| Extracting data for CO2 reporting | EMS | One-month period + Scope1/Scope2 columns → download the full CSV export |
| Determining alarm thresholds | OEE/RAM/EMS | Apply the mean ± σ of a stable operating period to an alarm threshold or to LIMIT_MAX in Predictive Analytics |
Frequently Asked Questions
What is counted and how (plugin assignment · what one failure is · planned stops · stop reasons · past periods) is collected in the OEE · RAM · EMS FAQ.
Q. The chart is empty and only a message is shown. A. You must select an equipment-level node in the left asset tree. Selecting only a higher level such as a line or site will not display data. After selecting equipment, click Query.
Q. I changed the plugin selector but the right-hand area stays the same. A. The tab switches automatically when the selector changes. If no data appears, click Query once more for the new plugin.
Q. OEE shows an abnormal value above 100%. A. Normally OEE cannot exceed 100% because it is the product of availability, performance, and quality. Values above 100% mean the input data (output quantity, ideal reference value) is configured incorrectly. Check the ideal cycle time in the asset metadata under Factory Management.
Q. RAM shows R(1h) = 0.99. Is that good? A. That is a very good value. R(1h)=0.99 means a 99% probability of running for one hour without failure. When R falls below 0.95, it is time to review the maintenance interval.
Q. EMS shows Scope1 as 0. Is that normal? A. If the site has no on-site fuel combustion (boilers, in-house generators, vehicles), Scope1 is 0. For equipment that uses only purchased electricity, having only Scope2 is normal.
Q. The per-unit kWh value suddenly jumped. A. If output was near zero during an interval while power was still being consumed, the per-unit value becomes very large. Reviewing Uptime and Downtime together will reveal the inefficiency of power being consumed during non-operating time.
Q. The work order column is empty. A. Either no work order was in progress at that time, or the asset-to-work-order mapping is missing. Check the work order registration for that asset on the Work Orders screen.
Q. What changes if I switch the chart from line to area? A. An area chart fills the space below the line with color, making cumulative totals easier to compare visually; a line chart makes it easier to compare exact trends of change.
Q. There are too many results and the chart is slow. A. Reduce the record count selector in the search area to 1,000, or shorten the period (to within one week).
Q. The downloaded CSV is too large. A. The CSV exports the full result set for the search conditions. Shorten the period or select only a single asset before downloading.
Related Screens
- Dashboard — Overall OEE shown on KPI cards
- Daily Statistics — Comparative analysis by site, line, and equipment
- Equipment — Operating status + alarms on equipment cards
- Work Orders — Cross-analysis with the work order column
- Predictive Analytics — Learning from stable intervals → threshold determination
- Data Point — Raw tag data trends
- Status Code Definitions — Equipment operating status (OEE) code mapping