ISO Data and Analytics (OEE / RAM / EMS)
Contents
- Overview
- Screen Layout
- Top — Search Area
- Left — Model (Asset Tree) Panel
- Right — Analytics Content (3 Tabs)
- Metric Definitions
- Usage Scenarios
- FAQ
- 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 in 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 asset tree and search area; only the content on the right changes, showing different charts and tables per 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 of 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. Reloads the tree on change |
Asset tree (assetTreeDiv) | Site → area → line → equipment → tag hierarchy |
| Search input | Toggled (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 shows 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 at that time |
| Equipment status | 70px | RUN/STOP/IDLE, etc. |
| Total | 60px | Total production quantity |
| Good | 60px | Number of good units |
| Defect | 60px | Number of defective units |
| Run time | 80px | Unit time (minutes/hours) |
| Down time | 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 (failure probability 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 for the interval |
| Per unit (kWh) | 80px | Power consumed per unit produced (for productivity/efficiency comparison) |
| Efficiency (%) | 60px | Energy efficiency |
| CO2 (kg) | 70px | Total CO2 emissions for the 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 the interval |
| Average (kW) | 70px | Average power in the interval |
Metric Definitions
The Three Components of OEE
| Metric | Calculation | Meaning |
|---|---|---|
| Availability | Run time ÷ planned operating time | Ratio of actual run time to the time the equipment was scheduled to run |
| Performance | Actual output ÷ ideal output | Actual throughput rate versus the ideal rate during run time |
| Quality | Good units ÷ total output | Proportion of good units among all output |
| OEE | Availability × Performance × Quality | Overall effectiveness (100% only when all three metrics are 100%) |
Key RAM Metrics
| Metric | Calculation | Unit | Meaning |
|---|---|---|---|
| MTBF | Total run time ÷ failure count | hours (h) | Mean time between failures — higher means better reliability |
| MTTR | Total repair time ÷ failure count | hours (h) | Mean repair time — lower means better maintainability |
| MA | MTBF ÷ (MTBF + MTTR) | % | Availability |
| R(t) | exp(-λt) | ratio | Probability of running without failure for time t (λ = failure rate) |
| M(t) | 1 − exp(-μt) | ratio | Probability that repair completes 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 |
|---|---|---|
| One-week OEE trend for a line | OEE tab | Period 7 days, plugin OEE → select the line asset → Query → compare the 4 series in the trend chart |
| Downtime cause analysis | OEE history | Click a row for a period with low OEE → check the work order ID → cross-analyze with Work Orders |
| Determining a maintenance interval (MTBF) | RAM tab | Check the average MTBF per asset in the RAM history → set the maintenance interval to about 1/3 of MTBF |
| New vs. aging equipment comparison | RAM | Compare MTBF, MTTR, and failure count 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 ± σ from a stable operating period as an Alarm threshold or as LIMIT_MAX in Forecast Analytics |
FAQ
Q. The chart is empty and only shows a message. A. You must select an equipment-level node in the left asset tree. Selecting a higher level such as a line or site alone will not display data. After selecting the equipment, click Query.
Q. I changed the plugin selector but the right-hand area did not change. 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. OEE is the product of availability, performance, and quality, so it normally never exceeds 100%. Values above 100% mean the input data (output, ideal reference values) 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 one hour without failure. When R drops below 0.95, it is time to review the maintenance interval.
Q. EMS Scope1 is 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 increased. A. If output in that interval was near zero while power was still being consumed, the per-unit value becomes very large. Viewing Run time and Down time together reveals the inefficiency of power 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 under the line with color, making cumulative totals easier to compare visually, while a line chart makes it easier to compare precise 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 narrow the period (within one week).
Q. The downloaded CSV is too large. A. The CSV exports the entire search condition result. Shorten the period or select only one asset before downloading to reduce the size.
Related Screens
- Dashboard — overall OEE shown on the KPI card
- Daily Statistics — comparative analysis by site, line, and equipment
- Equipment — operating status + alarms on the equipment card
- Work Orders — cross-analysis with the work order column
- Forecast Analytics — learn stable intervals → determine thresholds
- Data Point — raw tag data trends
- Status Code Definitions — equipment operating status (OEE) code mapping