Setting Up the OBIEE Repository and Dashboards

OBIEE Repository Setup

Follow the steps and the OBIEE version compatibility in the APS Family Pack Readme.

Dashboards

Oracle Manufacturing Operations Center includes:

Manufacturing Operations Center Catalog

The Manufacturing Operations Center Catalog provides the Plant Manager, Process Engineer, Asset Performance, Production Supervisor, Facilities Manager, and Ad hoc Dashboards with performance areas related to manufacturing operations. It uses the ISA-95 (Instrumentation, Systems and Automation Society) structure to integrate Enterprise Resource Planning (ERP) and shop floor manufacturing equipment and systems transactions. This combination enables the catalog to provide operational analytics visibility. The catalog uses data from multiple sources and builds a logical data model providing industry-rich operational metrics to be analyzed by multiple dimensions and hierarchies.

See: Oracle Manufacturing Operations Center User's Guide for details.

The manufacturing performance areas include the following:

Performance Areas Description
Agility Responsiveness Used to analyze flexibility related measures by system, plant, item, time and equipment.
Batch Analyzer Used to analyze usage and production variance and other work order related measures by system, item, plant and time.
Equipment Attributes Data Attributes associated to equipment entities.
Equipment Down Time Analysis Used to analyze the downtime duration of equipment.
Equipment Event Action Used to add and update event types and actions for equipment items. Using the Event Management Framework, MOC routes events and takes appropriate actions.
Equipment Scrap Analysis Used to analyze the scrap quantity reported for the equipment at different points of time.
Manufacturing Asset Performance Used to analyze overall equipment effectiveness and production loss analysis by system, plant, item, time, and equipment.
Plant Maintenance Used to analyze maintenance related downtime measures by system, time, and equipment.
Production Performance Used to analyze operation cycle time and its components of run, down, and idle time contributing to cycle time.
Quality Used to analyze first pass yield, scrap, reject, and rework measures by system, plant, time, and equipment.
Schedule Adherence Used to analyze production to performance and backlog related measures by system, plant, item, time, and equipment.
Service Level Used to analyze manufacturing performance relative to pegged sales orders shipped using request and promise dates by system, plant, item and time.
Sustainability Performance Used to analyze the consumption of sustainability aspect, the cost of sustainability aspect consumed, and emissions resulting from the usage of the sustainability aspect for an entity.
Production Sustainability Performance Used to analyze the production output based on the sustainability aspect consumption.
Equipment Sustainability Analysis Used to analyze the sustainability aspect consumption by equipment.

Plant Manager Dashboard

Overall Equipment Effectiveness (OEE) is a key metric that every plant manager monitors. The Plant Manager Dashboard provides a complete view of the equipment and helps the plant manager to assess where the source for production losses occur. The Plant Manager Dashboard and integrated reports provide the plant manager views of the production data for the plant in terms of overall equipment effectiveness, batch performance, schedule adherence, and production loss analysis for the departments and equipment on the shop floor.

Oracle Manufacturing Operations Center collects data from disparate sources into this single role-based dashboard that allows Plant Managers and staff to view manufacturing operations efficiently and effectively. The open and flexible BI technology from Oracle Fusion Middleware makes it easy to build and modify KPI's and dashboards.

See: Oracle Manufacturing Operations Center User's Guide

The following table identifies the dashboard pages and the reports made available to the Plant Manager role:

Dashboard Pages Reports
Equipment Performance (OEE) Overall Equipment Effectiveness by Plant
  Overall Equipment Effectiveness By Department (Bottom Performers)
  Overall Equipment Effectiveness Details By Plant
  Overall Equipment Effectiveness Details By Department
  Overall Equipment Effectiveness Trend by Plant
  Overall Equipment Effectiveness Trend by Department
OEE by Equipment Overall Equipment Effectiveness by Department
  Overall Equipment Effectiveness by Equipment (Bottom Performers)
  Overall Equipment Effectiveness Details by Department
  Overall Equipment Effectiveness Details by Equipment
  Overall Equipment Effectiveness Trend by Department
  Overall Equipment Effectiveness Trend by Equipment
Equipment Downtime Analysis Equipment Downtime Analysis
  Machine Availability Ratio Trend
Equipment Downtime Reasons Downtime Reasons
Production Slippage Trend Production Slippage Trend
Production Loss Analysis Production Loss Distribution
  Effective Production Capacity
  Production Loss Analysis
Production Loss Detail Production Loss Detail
Equipment Efficiency Analysis Equipment Efficiency Analysis
  Equipment Performance Ratio Trend
Equipment Efficiency Detail Equipment Efficiency Detail
Equipment Scrap Analysis Equipment Scrap Analysis
  First Pass Yield Trend
Equipment Scrap Reasons Equipment Scrap Reasons
Batch Performance Production Variance by Product Category
  Production Variance by Product
  PPM Trend (Month to Date)
  Batch Cycle Time Trend (Month to Date)
  Service Level Performance by Product Category
  Service Level Performance by Product
Batch Performance Detail Batch Performance Detail
Production Performance Performance to Schedule Measures by Plant
  Performance to Schedule Measures by Department
  Performance to Schedule Measures by Equipment (Bottom Performers)
  Production Slippage (Equipment)
  Current Month Production Slippage Trend by Department
  Current Month Production Slippage Trend by Equipment
Sustainability Performance Electricity Consumption
  Electricity Cost
  CO2 Emission
  Production Value Analysis by Product
  Trend by Period by All Departments
  Trend by Period by Department
  Ranking and Distribution - Department Ranking
  Ranking and Distribution by Department
Ranking and Distribution by Usage Category

Process Engineer Dashboard

The Process Engineer Dashboard enables plant engineers to view the summarized information of process parameters and to know the average value of temperature or pressure running on a particular equipment in the last hour. It also allows correlation between equipment output, status and the influencing variables. From the Process Engineer Dashboard, based on the time and equipment dimensions, you can view the following reports:

  1. Parameter Hourly Run Chart

  2. Equipment Output - Process Analysis

  3. Equipment Status - Process Analysis

See: Oracle Manufacturing Operations Center User's Guide.

Asset Performance Dashboard

Asset Performance Dashboard is a role-based dashboard that provides reporting capabilities for production and maintenance assets within an organization. The dashboard displays the reports for the shop floor events such as breakdown, excessive scrap, unstable equipment and also details of asset status, production performance, output, scrap, and operating parameters.

Dashboard Pages Reports
  OEE By Asset
  OEE Breakup by Asset
  Asset Events
  Asset Production Performance
  Asset Output and Scrap
  Asset Status Trend
  Asset Downtime Analysis
  Asset Operation Parameter Trend
Non-Production Assets Asset Events
  Asset Status Trend
  Asset Downtime Analysis
  Asset Operation Parameter Trend

See: Oracle Manufacturing Operations Center User's Guide.

Production Supervisor Dashboard

Production Supervisor Dashboard generates reports that fetch data from shop floor equipment and provide real-time information about equipment status and production performance. Using this dashboard you can generate the following reports:

See: Oracle Manufacturing Operations Center User's Guide.

Facilities Manager

The Facilities Manager Dashboard provides information and analysis of electricity consumption, electricity cost, and CO2 emission and helps the facility manager monitor the electricity costs and CO2 emissions. Facilities Manager Dashboard is based on seeded 5 levels Facility Hierarchy as follows:

See: Oracle Manufacturing Operations Center User's Guide

The following table identifies the dashboard pages and the reports made available to the Facilities Manager role:

Dashboard Pages Reports
Summary Electricity Consumption
  Electricity Cost
  CO2 Emission
  Trend by Period- All sites
Trend by Period - By Site
  Ranking and Distribution- Site Ranking
Ranking and Distribution - Distribution by Site
Ranking and Distribution - Distribution by Usage Category
Site Electricity Consumption
  Electricity Cost
  CO2 Emission
  Trend by Period- All Buildings
Trend by Period- By Building
  Ranking and Distribution - Building Ranking
Ranking and Distribution - Distribution by Building
Ranking and Distribution - Distribution by Usage Category
Building Electricity Consumption
  Electricity Cost
  CO2 Emission
  Trend by Period - All Floors
Trend by Period - By Floor
  Ranking and Distribution - Floor Ranking
Ranking and Distribution - Distribution by Floor
Ranking and Distribution - Distribution by Usage Category
Floor Electricity Consumption
  Electricity Cost
  CO2 Emission
  Trend by Period - All Floor Sections
Trend by Period - By Floor Section
  Ranking and Distribution - Floor Section Ranking
Ranking and Distribution - Distribution by Floor Section
Ranking and Distribution - Distribution by Usage Category
Floor Section Equipment Summary
  Trend by Period - All Equipment
Trend by Period - By Equipment
  Ranking and Distribution - Equipment Ranking
Ranking and Distribution - Distribution by Equipment
Ranking and Distribution - Distribution by Usage Category
  Electricity Consumption Trend
  Parameter Monitoring
  Equipment Status Trend
  Equipment Summary
  Equipment Hourly Summary
  Equipment Hourly Detail

Ad hoc Analysis

Ad hoc Analysis reports enable you to compare electricity consumption with any parameter like temperature or pressure for single or multiple time periods and single or multiple entities.

The following table identifies the reports made available for ad hoc analysis:

Ad hoc Pages Reports
Single Entity Electricity Consumption and Parameter Monitoring
Multiple Entities Electricity Consumption and Parameter Monitoring
Compare Periods Electricity Consumption and Parameter Monitoring