Oracle Business Intelligence Applications User’s Guide
for Enterprise Asset Management Analytics

Release
7.9.6.3 Extension Pack

Contents

Preface. 4

Audience. 4

Documentation
Accessibility. 4

Accessibility
of Code Examples in Documentation. 4

Accessibility
of Links to External Web Sites in Documentation. 4

TTY
Access to Oracle Support Services. 5

Related
Documents.
5

Conventions. 5

Overview
of Oracle Enterprise Asset Management (EAM) Analytics. 5

Oracle
EAM Analytics Subject Area. 5

Facts
Descriptions. 5

Subject
Area Details: 6

Kimball
Matrix:
22

Oracle
EAM Analytics Dashboard. 24

Executive
KPIs Dashboard Page: 24

Workorders
Report.
24

Cost
Report.
24

Inventory
Report.
24

Quality
Report.
24

Resource
Report.
25

Work
Order Analysis by Plant Report. 25

Maintenance
Cost Summary Dashboard Page. 25

Maintenance
Cost Details Report. 25

Breakdown
Cost & Preventive Cost Analysis Report. 26

Cost
Distribution Report. 26

Work
Order Summary Dashboard Page. 26

Work
Order Summary by Asset Group Report. 26

Backlog
by Asset Group Report. 27

Work
Order Completion by Aging Bucket Report. 27

Work
Order Completion Report. 27

Inventory
and Costing Dashboard Page. 28

On-Hand
Inventory Details by Organization Report. 28

On-Hand
Inventory Monthly Trend   Report. 28

Quality
Analysis Dashboard Page. 28

Failure
Details Report. 29

Failure
Analysis by Asset Description Report. 29

Down
Time by Month Report. 29

PMs
Completion Report. 29

Down
Time By Asset Group Report. 29

Resource
Analysis Dashboard Page. 30

Resource
Efficiency Report. 30

Asset
Genealogy
Dashboard Page. 30

Asset
Genealogy Report. 30

Maintenance
Cost by Asset Description report. 31

Prevention
& Unplanned Maintenance Cost by Asset Description Report. 31

Preface

Oracle Business Intelligence Applications are comprehensive
prebuilt solutions that deliver pervasive intelligence across an organization,
empowering users at all level, from front line operational users to senior
management, with the key information they need to maximize effectiveness.
Intuitive and role-based, these solutions transform and integrate data from a
range of enterprise sources, including Siebel, Oracle, PeopleSoft, SAP, and
corporate data warehouses, into actionable insight that enables more effective
actions, decisions, and processes.

Oracle Business Intelligence Applications are built on Oracle
Business Intelligence Suite Enterprise Edition, a comprehensive next-generation
BI and analytics platform.

This guide explains how to install, set up, configure, and
customize Oracle Business Intelligence Applications Version 7.9.6.3 Extension
Pack.

Oracle recommends reading Oracle Business Intelligence
Applications Release Notes before installing or using Oracle Business
Intelligence Applications. The Oracle Business Intelligence Applications Release
Notes are available:

·
On the Oracle Business Intelligence Applications CD-ROM.

·
On the Oracle Technology Network at http://www.oracle.com/technology/documentation/bi_apps.html (to register for a free account on the Oracle
Technology Network, go to http://www.oracle.com/technology/about/index.html).

Audience

This document is intended for BI managers and implementers of
Oracle Business Intelligence Applications.

Documentation
Accessibility

Our goal is to make Oracle products, services, and supporting
documentation accessible, with good usability, to the disabled community. To
that end, our documentation includes features that make information available to
users of assistive technology. This documentation is available in HTML format,
and contains markup to facilitate access by the disabled community.
Accessibility standards will continue to evolve over time, and Oracle is
actively engaged with other market-leading technology vendors to address
technical obstacles so that our documentation can be accessible to all of our
customers. For more information, visit the Oracle Accessibility Program Web site
at http://www.oracle.com/accessibility/.

Accessibility of Code
Examples in Documentation

Screen readers may not always correctly read the code
examples in this document. The  conventions for writing code require that
closing braces should appear on an otherwise empty line; however, some screen
readers may not always read a line of text  that consists solely of a
bracket or brace.

Accessibility of Links to
External Web Sites in Documentation

This documentation may contain links to Web sites of other
companies or organizations that Oracle does not own or control. Oracle neither
evaluates nor makes any representations regarding the accessibility of these Web
sites.

TTY Access to Oracle Support
Services

Oracle provides dedicated Text Telephone (TTY) access to
Oracle Support Services within the United States of America 24 hours a day, 7
days a week. For TTY support, call 800.446.2398. Outside the United States, call
+1.407.458.2479.

Related Documents

For more information, see the following documents in the
Oracle Business Intelligence Applications Release 7.9.6.3 Extension Pack
documentation set (available at  http://www.oracle.com/technology/documentation/bi_apps.html):

·
Oracle Business Intelligence
Applications Release Notes

·
System Requirements and Supported
Platforms for Oracle Business Intelligence Applications for Oracle Data
Integrator Users

Conventions

The following text conventions are used in this document:

·
Boldface type indicates graphical user
interface elements associated with an action, or terms defined in text or the
glossary.

·
Italic type indicates book titles,
emphasis, or placeholder variables for which you supply particular values.

·
Monospace type indicates commands
within a paragraph, URLs, codein examples, text that appears on the screen, or
text that you enter.

Overview of Oracle Enterprise Asset Management
(EAM) Analytics

Oracle EAM Analytics is a
prebuilt analytical solution that is part of the Oracle BI Applications product
family.

Oracle EAM provides metrics around Maintenance Costs
(Preventive & Breakdown), work order backlogs, planned and unplanned work
orders and resource and material utilization on the work orders. Pre-built
dashboards help users analyze the maintenance costs, failures and failure costs,
resource utilizations and asset genealogy.

Oracle EAM Analytics Subject Area

The Oracle EAM Analytics subject area provides KPIs based on
the analytical layer of Oracle Business Intelligence Enterprise Edition (OBIEE).
Since these KPI's are available on a metadata-driven Oracle Business
Intelligence tool, user can personalize and modify existing reports and
dashboards. It also provides flexibility to add new and modify existing
KPIs.

Facts Descriptions

The measures and KPIs of Oracle EAM Analytics are grouped
under the following facts

Fact – Asset Maintenance Costs

This Fact contains metrics on various Costs incurred during
Asset Maintenance. This Fact is analyzable by Time, Organization, Asset,
and Work Order.

Fact – Asset Maintenance Failures

This Fact contains metrics on number of failures, time
required to repair and the respective cost incurred. This Fact is
analyzable by Asset, Time, Organization, Department and Work
Order.

Fact – Asset Maintenance Workorders

This Fact provides metrics on Planned and Unplanned Work
Orders, Yield, Backlog related measures and Work Order Completion aging
Bucketing. This fact is analyzable by Time, Organization, Asset and Work
Order.

Fact – Inventory Balance

This fact contains measures related to Inventory Items i.e.
Various Quantities and their respective Amounts. This Fact is analyzable
by Time, Organization and Product.

Fact – Resource Analyzer

This Fact contains metrics on Available and Standard Hours
for a Resource and Utilization and Efficiency metrics. This Fact is
analyzable by Work Order, Time, Resource, Department and
Organization.

Fact – Asset Maintenance Transactions

This Fact contains metrics on Material and Resource
transactions and is analyzable by Time, Product, Inventory Product,
Organization and Maintenance Work Orders.

Subject Area Details:

The following table provides the details of the subject area
present for Oracle EAM Analytics.

Presentation Table

Presentation Column

Description

Maintenance Work Orders

Actual Completion Date

Work Order Actual Completion Date

Maintenance Work Orders

Actual Start Date

Work Order Actual Start Date

Maintenance Work Orders

Date Closed

Work Order Closed Date

Maintenance Work Orders

Date Released

Work Order Released Date

Maintenance Work Orders

Work Order Name

Maintenance Work Oder Name

Maintenance Work Orders

Work Order Description

Maintenance Work Order Description

Maintenance Work Orders

Work Order Type  Description

The type of the maintenance work order

Maintenance Work Orders

Planned Completion Date

Planned Completion Date

Maintenance Work Orders

Planned Start Date

Planned Start Date

Maintenance Work Orders

Work Order status

Status of the Maintenance Workorder

Department

Department Name

Name of the Department

Department

Department Code

Code of the Department Name

Asset Install Location

Location Name

Identifies the business location name

Asset Install Location

Location Description

This is the description of the location

Asset Install Location

Location Type

Identifies the type of location

Asset Install Location

Disabled Flag

This flag indicates whether the location is enabled or not

Asset Install Location

Level1 Name

Identifies the first level in location hierarchy

Asset Install Location

Level2 Name

Identifies the second level in location hierarchy

Asset Install Location

Level3 Name

Identifies the third level in location hierarchy

Asset Install Location

Level4 Name

Identifies the fourth level in location hierarchy

Asset Install Location

Level5 Name

Identifies the fifth level in location hierarchy

Asset Install Location

Level6 Name

Identifies the sixth level in location hierarchy

Asset Install Location

Level7 Name

Identifies the seventh level in location
hierarchy

Asset Install Location

Level8 Name

Identifies the eight level in location hierarchy

Asset Install Location

Level9 Name

Identifies the ninth level in location hierarchy

Asset Install Location

Level10 Name

Identifies the tenth level in location hierarchy

Asset Install Location

Top Level Name

Identifies the top most level in location
hierarchy

Asset

Accounting Class Code

This is the Maintenance Account Class

Asset

Acquired Date

This is the Date on the Which the maintenance Asset is
acquired

Asset

Active Flag

Status of the Maintenance Asset

Asset

Asset Group

Name of the Asset Group

Asset

Asset Number

Maintenance Asset Number

Asset

Asset Description

Maintenance Asset Description

Asset

Expiry Date

Date on Which the Asset is going to Expire

Asset

External Reference

This is the External Reference of the Maintenance
Asset

Asset

Installed Date

This is the Date on which the Asset is installed

Asset

Serial Number

This is the Unique Serial Number of the Maintenance
Asset

Asset

Asset Cost

Market price of the Asset

Asset

Asset Status

This is the  Maintenance Asset Status

Organization

Org Number

This is a unique number for identifying the business
organization. If several organizations exist with the same name this could
be a distinguishing factor

Organization

Org Name

This the name of the business organization

Organization

Org Hierarchy 1 Number

Identifies the first level in organization hierarchy

Organization

Org Hierarchy 1 Name

This is the name of the first level in organization
hierarchy

Organization

Org Hierarchy 2 Number

Identifies the second level in organization hierarchy

Organization

Org Hierarchy 2 Name

This is the name of the second level in organization
hierarchy

Organization

Org Hierarchy 3 Number

Identifies the third level in organization hierarchy

Organization

Org Hierarchy 3 Name

This is the name of the third level in organization
hierarchy

Organization

Org Hierarchy 4 Number

Identifies the fourth level in organization hierarchy

Organization

Org Hierarchy 4 Name

This is the name of the fourth level in organization
hierarchy

Organization

Org Hierarchy 5 Number

Identifies the fifth level in organization hierarchy

Organization

Org Hierarchy 5 Name

This is the name of the fifth level in organization
hierarchy

Organization

Org Hierarchy 6 Number

Identifies the sixth level in organization hierarchy

Organization

Org Hierarchy 6 Name

This is the name of the sixth level in organization
hierarchy

Organization

Org Hierarchy 7 Number

Identifies the seventh level in organization hierarchy

Organization

Org Hierarchy 7 Name

This is the name of the seventh level in organization
hierarchy

Organization

Org Hierarchy 8 Number

Identifies the eight  level in organization hierarchy

Organization

Org Hierarchy 8 Name

This is the name of the eight level in organization
hierarchy

Organization

Org Hierarchy 9 Number

Identifies the ninth level in organization hierarchy

Organization

Org Hierarchy 9 Name

This is the name of the ninth level in organization
hierarchy

Organization

Org Hierarchy 10 Number

Identifies the tenth level in organization hierarchy

Organization

Org Hierarchy 10 Name

This is the name of the tenth level in organization
hierarchy

Organization

Org Hierarchy 11 Number

Identifies the eleventh level in organization hierarchy

Organization

Org Hierarchy 11 Name

This is the name of the eleventh level in organization
hierarchy

Organization

Org Hierarchy 12 Number

Identifies the  level twelve in organization hierarchy

Organization

Org Hierarchy 12 Name

This is the name of  level twelve in organization
hierarchy

Organization

Org Hierarchy 13 Number

Identifies the  level thirteen in organization
hierarchy

Organization

Org Hierarchy 13 Name

This is the name of  level thirteen in organization
hierarchy

Organization

Org Top Hierarchy Number

Identifies the top most level in organization
hierarchy

Organization

Org Top Hierarchy Name

This is the name of top most level in organization
hierarchy

Product

Brand

This the brand to which the product belongs

Product

Color

This identifies the color of the product

Product

Configurable Product Flag

This indicates whether the product is configurable or not

Product

Configuration Category

This code identifies the configuration category

Product

Discontinuation Date

This is the date on which the product was discontinued from
the market

Product

Division

This code identifies the division. Products can be
classified by the division code to determine their sales or business
area

Product

Make Buy Flag

This flag indicates whether the product was made in the
organization or bought by the organization. Possible values include 'M' or
'B'

Product

Plant Safety Stock

This is a product safety stock level at a plant. The safety
stock level helps to maintain sufficient on hand inventory to prevent
stock outs during replenishment cycles

Product

Product Group

This is a product group code. Product with similar
attributes can be grouped The product hierarchies can be defined based on
product groups

Product

Product Group Description

This is the description of product group code

Product

Product Name

This is a detailed description of the product

Product

Product Number

This is a unique number to identify the product

Product

Product Repurchase Period

This is the expected period between the purchases of a
product. It is used for sensitivity and profile styles of analysis. The
repurchase period is stored in monthly units

Product

Product Type Code

This code identifies the product type

Product

Product Type Description

This is the description of the product type code

Product

Shelf Life

This is the shelf life of the product

Product

Source Of Supply

A field for determining any unique sources of supply for
the product - internal or external

Product

Standard UOM Code

This is the standard unit of measure code in which the
product is managed

Resource

Resource Group Description

This is the Group Description Associated with the Resource
Group

Resource

Resource Name

Name of the Resource

Resource

Resource Number

Unique Code of the Resource

Resource

Resource Group

This is the Group Name Associated with the
Resources

Resource

Resource Type

This is the Resource type

Asset Specification

Asset Attribute1

Identifies the value in Asset Attribute1

Asset Specification

Asset Attribute2

Identifies the value in Asset Attribute2

Asset Specification

Asset Attribute3

Identifies the value in Asset Attribute3

Asset Specification

Asset Attribute4

Identifies the value in Asset Attribute4

Asset Specification

Asset Attribute5

Identifies the value in Asset Attribute5

Asset Specification

Asset Attribute6

Identifies the value in Asset Attribute6

Asset Specification

Asset Attribute7

Identifies the value in Asset Attribute7

Asset Specification

Asset Attribute8

Identifies the value in Asset Attribute8

Asset Specification

Asset Attribute9

Identifies the value in Asset Attribute9

Asset Specification

Asset Attribute10

Identifies the value in Asset Attribute10

Asset Specification

Asset Attribute11

Identifies the value in Asset Attribute11

Asset Specification

Asset Attribute12

Identifies the value in Asset Attribute12

Asset Specification

Asset Attribute13

Identifies the value in Asset Attribute13

Asset Specification

Asset Attribute14

Identifies the value in Asset Attribute14

Asset Specification

Asset Attribute15

Identifies the value in Asset Attribute15

Asset Specification

Asset Attribute16

Identifies the value in Asset Attribute16

Asset Specification

Asset Attribute17

Identifies the value in Asset Attribute17

Asset Specification

Asset Attribute18

Identifies the value in Asset Attribute18

Asset Specification

Asset Attribute19

Identifies the value in Asset Attribute19

Asset Specification

Asset Attribute20

Identifies the value in Asset Attribute20

Asset Specification

Asset Attribute21

Identifies the value in Asset Attribute21

Asset Specification

Asset Attribute22

Identifies the value in Asset Attribute22

Asset Specification

Asset Attribute23

Identifies the value in Asset Attribute23

Asset Specification

Asset Attribute24

Identifies the value in Asset Attribute24

Asset Specification

Asset Attribute25

Identifies the value in Asset Attribute25

Asset Specification

Asset Attribute26

Identifies the value in Asset Attribute26

Asset Specification

Asset Attribute27

Identifies the value in Asset Attribute27

Asset Specification

Asset Attribute28

Identifies the value in Asset Attribute28

Asset Specification

Asset Attribute29

Identifies the value in Asset Attribute29

Asset Specification

Asset Attribute30

Identifies the value in Asset Attribute30

Asset Specification

Asset Attribute31

Identifies the value in Asset Attribute31

Asset Specification

Asset Attribute32

Identifies the value in Asset Attribute32

Asset Specification

Asset Attribute33

Identifies the value in Asset Attribute33

Asset Specification

Asset Attribute34

Identifies the value in Asset Attribute34

Asset Specification

Asset Attribute35

Identifies the value in Asset Attribute35

Asset Specification

Asset Attribute36

Identifies the value in Asset Attribute36

Asset Specification

Asset Attribute37

Identifies the value in Asset Attribute37

Asset Specification

Asset Attribute38

Identifies the value in Asset Attribute38

Asset Specification

Asset Attribute39

Identifies the value in Asset Attribute39

Asset Specification

Asset Attribute40

Identifies the value in Asset Attribute40

Asset Specification

Asset Attribute41

Identifies the value in Asset Attribute41

Asset Specification

Asset Attribute42

Identifies the value in Asset Attribute42

Asset Specification

Asset Attribute43

Identifies the value in Asset Attribute43

Asset Specification

Asset Attribute44

Identifies the value in Asset Attribute44

Asset Specification

Asset Attribute45

Identifies the value in Asset Attribute45

Asset Specification

Asset Attribute46

Identifies the value in Asset Attribute46

Asset Specification

Asset Attribute47

Identifies the value in Asset Attribute47

Asset Specification

Asset Attribute48

Identifies the value in Asset Attribute48

Asset Specification

Asset Attribute49

Identifies the value in Asset Attribute49

Asset Specification

Asset Attribute50

Identifies the value in Asset Attribute50

Asset Specification

Asset Attribute51

Identifies the value in Asset Attribute51

Asset Specification

Asset Attribute52

Identifies the value in Asset Attribute52

Asset Specification

Asset Attribute53

Identifies the value in Asset Attribute53

Asset Specification

Asset Attribute54

Identifies the value in Asset Attribute54

Asset Specification

Asset Attribute55

Identifies the value in Asset Attribute55

Asset Specification

Asset Attribute56

Identifies the value in Asset Attribute56

Asset Specification

Asset Attribute57

Identifies the value in Asset Attribute57

Asset Specification

Asset Attribute58

Identifies the value in Asset Attribute58

Asset Specification

Asset Attribute59

Identifies the value in Asset Attribute59

Asset Specification

Asset Attribute60

Identifies the value in Asset Attribute60

Asset Specification

Asset Attribute61

Identifies the value in Asset Attribute61

Asset Specification

Asset Attribute62

Identifies the value in Asset Attribute62

Asset Specification

Asset Attribute63

Identifies the value in Asset Attribute63

Asset Specification

Asset Attribute64

Identifies the value in Asset Attribute64

Asset Specification

Asset Attribute65

Identifies the value in Asset Attribute65

Asset Specification

Asset Attribute66

Identifies the value in Asset Attribute66

Asset Specification

Asset Attribute67

Identifies the value in Asset Attribute67

Asset Specification

Asset Attribute68

Identifies the value in Asset Attribute68

Asset Specification

Asset Attribute69

Identifies the value in Asset Attribute69

Asset Specification

Asset Attribute70

Identifies the value in Asset Attribute70

Asset Specification

Asset Attribute71

Identifies the value in Asset Attribute71

Asset Specification

Asset Attribute72

Identifies the value in Asset Attribute72

Asset Specification

Asset Attribute73

Identifies the value in Asset Attribute73

Asset Specification

Asset Attribute74

Identifies the value in Asset Attribute74

Asset Specification

Asset Attribute75

Identifies the value in Asset Attribute75

Asset Specification

Asset Attribute76

Identifies the value in Asset Attribute76

Asset Specification

Asset Attribute77

Identifies the value in Asset Attribute77

Asset Specification

Asset Attribute78

Identifies the value in Asset Attribute78

Asset Specification

Asset Attribute79

Identifies the value in Asset Attribute79

Asset Specification

Asset Attribute80

Identifies the value in Asset Attribute80

Asset Specification

Asset Attribute81

Identifies the value in Asset Attribute81

Asset Specification

Asset Attribute82

Identifies the value in Asset Attribute82

Asset Specification

Asset Attribute83

Identifies the value in Asset Attribute83

Asset Specification

Asset Attribute84

Identifies the value in Asset Attribute84

Asset Specification

Asset Attribute85

Identifies the value in Asset Attribute85

Asset Specification

Asset Attribute86

Identifies the value in Asset Attribute86

Asset Specification

Asset Attribute87

Identifies the value in Asset Attribute87

Asset Specification

Asset Attribute88

Identifies the value in Asset Attribute88

Asset Specification

Asset Attribute89

Identifies the value in Asset Attribute89

Asset Specification

Asset Attribute90

Identifies the value in Asset Attribute90

Asset Specification

Asset Attribute91

Identifies the value in Asset Attribute91

Asset Specification

Asset Attribute92

Identifies the value in Asset Attribute92

Asset Specification

Asset Attribute93

Identifies the value in Asset Attribute93

Asset Specification

Asset Attribute94

Identifies the value in Asset Attribute94

Asset Specification

Asset Attribute95

Identifies the value in Asset Attribute95

Asset Specification

Asset Attribute96

Identifies the value in Asset Attribute96

Asset Specification

Asset Attribute97

Identifies the value in Asset Attribute97

Asset Specification

Asset Attribute98

Identifies the value in Asset Attribute98

Asset Specification

Asset Attribute99

Identifies the value in Asset Attribute99

Asset Specification

Asset Attribute100

Identifies the value in Asset Attribute100

Time

Date

Calendar date in the Year

Time

Week

Calendar Week Number in the Year

Time

Month

Calendar Month in the Year

Time

Quarter

Calendar Quarter in the Year

Time

Year

Calendar Year

Time

Enterprise Week

Week number in the enterprise year

Time

Enterprise Period

Month number in the enterprise year

Time

Enterprise Quarter

Quarter number in the enterprise year

Time

Enterprise Year

Enterprise Year

Time

Fiscal Date

Fiscal Date

Time

Fiscal Period

Fiscal Month in fiscal year

Time

Fiscal Period Number

Fiscal Month number in fiscal year

Time

Fiscal Week Name

Fiscal Week number in fiscal year

Time

Fiscal Half

Fiscal Half year number in fiscal year

Time

Fiscal Quarter

Fiscal Quarter in fiscal year

Time

Fiscal Year

Fiscal Year

Time

Fiscal Calendar name

Calendar Name of fiscal year

Fact - Asset Maintenance Costs

Actual Equipment Cost

Actual equipment cost incurred for the maintenance
workorder

Fact - Asset Maintenance Costs

Actual Labor Cost

Actual labor cost incurred for the maintenance
workorder

Fact - Asset Maintenance Costs

Actual Maintenance Cost

Actual Maintenance Cost of the Maintenance Work
order

Fact - Asset Maintenance Costs

Actual Material Cost

Actual Material cost incurred for the maintenance
workorder

Fact - Asset Maintenance Costs

Breakdown Cost

Sum of actual material cost , actual labor cost and actual
equipment  cost incurred for the workorder where shutdown is
required

Fact - Asset Maintenance Costs

Estimated Maintenance Cost

Total Estimated Maintenance Cost of the Work Order This
include System and Manual Estimates

Fact - Asset Maintenance Costs

Manual Estimated Equipment Cost

Manually Estimated Equipment cost for the Maintenance
workorder

Fact - Asset Maintenance Costs

Manual Estimated Labor Cost

Manually Estimated Labour cost for the Maintenance
workorder

Fact - Asset Maintenance Costs

Manual Estimated Material Cost

Manually Estimated Material cost for the Maintenance
workorder

Fact - Asset Maintenance Costs

Preventive Cost

Total Maintenance Cost for Planned Workorders

Fact - Asset Maintenance Costs

System Estimated Equipment Cost

System Estimated equipment cost for the maintenance
workorder

Fact - Asset Maintenance Costs

System Estimated Labour Cost

System Estimated  Labor cost for the maintenance
workorder

Fact - Asset Maintenance Costs

System Estimated Material Cost

System Estimated Material cost for the maintenance
workorder

Fact - Asset Maintenance Costs

YTD Actual Maintenance Cost

is the current year to date maintenance cost incurred on an
asset

Fact - Asset Maintenance Costs

YTD Estimated Maintenance Cost

is the current year to date estimated maintenance cost of
an asset

Fact - Asset Maintenance Costs

Year Ago Actual Maintenance Cost

is the prior year maintenance cost incurred on an
asset

Fact - Asset Maintenance Costs

Year Ago Estimated Maintenance Cost

is the prior year estimated maintenance cost of an
asset

Fact - Asset Maintenance Failures

Days Between Failures

This is the  Average Failure time between Different
Failures in days

Fact - Asset Maintenance Failures

Failure Cost

Total Cost of the Failure for the Assets

Fact - Asset Maintenance Failures

No. of Failures

Number of Failure Instances

Fact - Asset Maintenance Failures

Mean Time Between Failures (Days)

This is the Mean Time Between Different Instances of
Failure in Days

Fact - Asset Maintenance Failures

Mean Time To Repair (Days)

This is the Mean time taken to Repair the Asset

Fact - Asset Maintenance Failures

Prior YTD Failure Cost

This is the Prior Year YTD  Failure Cost of the
Asset

Fact - Asset Maintenance Failures

Time To Repair

This is the Total Time taken to Repair the Asset

Fact - Asset Maintenance Failures

Year Ago failure Cost

Failure Cost as of Last Year

Fact - Asset Maintenance Failures

YTD Failure Cost

This is the YTD Failure cost of the Assets

Fact - Asset Maintenance Workorders

0-5 Days Workorder Completion Aging

Total No. of Work orders which are completed in between 0-5
Days

Fact - Asset Maintenance Workorders

11-15 Days Workorder Completion Aging

Total No. of Work orders which are completed in between
11-15 Days

Fact - Asset Maintenance Workorders

16-20 Days Workorder Completion Aging

Total No. of Work orders which are completed in between
16-20 Days

Fact - Asset Maintenance Workorders

6-10 Days Workorder Completion Aging

Total No. of Work orders which are completed in between
6-10 Days

Fact - Asset Maintenance Workorders

>20 Days Workorder Completion Aging

Total No. of Work orders which are completed in More than
20 Days

Fact - Asset Maintenance Workorders

Backlog %

This is the total Backlog% as of the Last Run
Date

Fact - Asset Maintenance Workorders

Backlog Work Orders

This is the total Backlog Workorders (Planned
Workorders-Completed Work Orders)as of the Last Run Date

Fact - Asset Maintenance Workorders

Count of Work Orders

Total Count of Workorders

Fact - Asset Maintenance Workorders

Days Delayed

This is the No. of Days Delayed from the Planned Completion
Date to the Actual Completion Date of the  Maintenance Work
Order

Fact - Asset Maintenance Workorders

Down Time

Total Down Time of the Asset

Fact - Asset Maintenance Workorders

On-Time Completion

Total Work Orders Completed before the Planned/Scheduled
Completion Date

Fact - Asset Maintenance Workorders

On-Time Completion %

This is the % of On-Time Completion with respect to the
Total Work Orders

Fact - Asset Maintenance Workorders

Past Due Backlog %

This is the % Measure of Past Due Backlog Work orders with
the Total Workorders

Fact - Asset Maintenance Workorders

Past Due Backlog Quantity

Total Work Orders Which are not Completed as of today and
crossed Planned/Schedule Completion Date

Fact - Asset Maintenance Workorders

Planned Workorders

Total Count of Work Orders which are Planned

Fact - Asset Maintenance Workorders

Start Quantity

Work Order Count

Fact - Asset Maintenance Workorders

Expected Yield

Expected yield for a  workorder

Fact - Asset Maintenance Workorders

Unplanned Workorders

Total Count of Work Orders which are not Planned

Fact - Resource Analyzer

Available Hours

Total Hours Available for the Resource

Fact - Resource Analyzer

Resource Utilization

Actual Utilization of the Resources in an organization when
compared to the Available Hours

Fact - Resource Analyzer

Resource Efficiency

Actual Hours / Standard Hours

Fact - Resource Analyzer

Standard Hours

Standard Hours Required for completing the
workorder/Job

Fact - Asset Maintenance Transactions

Actual Material Usage Quantity

This is the Actual Material Consumed for the Maintenance
Work Orders

Fact - Asset Maintenance Transactions

Actual Material Usage Value

This is the Actual Material Cost for the Maintenance Work
Orders

Fact - Asset Maintenance Transactions

Actual Resource Usage Hours

This is the Resource Actual Hours spent on the Maintenance
Work Orders

Fact - Asset Maintenance Transactions

Actual Resource Usage Value

This Is the Actual Resource Value for the Maintenance Work
Orders

Fact - Inventory Balance

Inventory Part #

Total Count of Inventory Items existing in the maintenance
organization

Fact - Inventory Balance

Inventory Parts Value

Total value of Inventory Items existing in the maintenance
organization

Fact - Inventory Balance

Spares Value

Total value of spares in maintenance organization

Fact - Inventory Balance

Tools Value

Total value of tools in maintenance organization

Fact - Inventory Balance

Available Amount

This metric is the quantity of product available to fill
open orders.  Available product is defined as unrestricted inventory
that is not reserved, blocked or otherwise unavailable for immediate
demand fulfilment. The Available Quantity metric an important component
for understanding historical inventory fluctuations, stock outs, and
allocation situations. By analyzing inventory activity over time,
slow-moving and obsolete materials can be identified

Fact - Inventory Balance

Available Quantity

This metric is the quantity of product available to fill
open orders.  Available product is defined as unrestricted inventory
that is not reserved, blocked or otherwise unavailable for immediate
demand fulfilment. The Available Quantity metric an important component
for understanding historical inventory fluctuations, stock outs, and
allocation situations. By analyzing inventory activity over time,
slow-moving and obsolete materials can be identified

Fact - Inventory Balance

Available Consignment Amount

Quantity in the warehouse that belongs to a consignment
vendor and is not subject to usage restrictions. A consignment vendor
retains ownership of the quantity until it is withdrawn from
stores

Fact - Inventory Balance

Available Consignment Quantity

Quantity in the warehouse that belongs to a consignment
vendor and is not subject to usage restrictions. A consignment vendor
retains ownership of the quantity until it is withdrawn from
stores

Fact - Inventory Balance

Block Consignment Amount

Quantity of all blocked batches that belong to a
consignment vendor. Example of batches are : Production lots, delivery
lots etc

Fact - Inventory Balance

Block Consignment Quantity

Quantity of all blocked batches that belong to a
consignment vendor. Example of batches are : Production lots, delivery
lots etc

Fact - Inventory Balance

Blocked Amount

This is the total physical quantity of the product under
hold for specific reasons (in inventory unit if measure).The quantity
would become available for use once the hold is released -- these would
typically include stocks that may have been damaged slightly and need to
undergo a re-certification process etc.

Fact - Inventory Balance

Blocked Quantity

This is the total physical quantity of the product under
hold for specific reasons (in inventory unit if measure).The quantity
would become available for use once the hold is released -- these would
typically include stocks that may have been damaged slightly and need to
undergo a re-certification process etc.

Fact - Inventory Balance

In Transit Amount

This is the total physical quantity in transit for the
product (in inventory unit of measure)

Fact - Inventory Balance

In Transit Quantity

This is the total physical quantity in transit for the
product (in inventory unit of measure)

Fact - Inventory Balance

Inspection Amount

This is the total physical quantity of the product under
inspection (in inventory unit of measure). This quantity would become
available for use once they pass inspection

Fact - Inventory Balance

Inspection Consignment Amount

Quantity in the warehouse that belongs to a consignment
vendor and is in quality inspection. A consignment vendor retains
ownership of the quantity until it is withdrawn from the stores

Fact - Inventory Balance

Inspection Consignment Quantity

Quantity in the warehouse that belongs to a consignment
vendor and is in quality inspection. A consignment vendor retains
ownership of the quantity until it is withdrawn from the stores

Fact - Inventory Balance

Inspection Quantity

This is the total physical quantity of the product under
inspection (inventory unit of measure). The quantity would become
available for use once they pass inspection.

Fact - Inventory Balance

Obsolete Inventory Value

Inventory Value that got obsolete or expired

Fact - Inventory Balance

Obsolete Inventory Quantity

Inventory Quantity that got obsolete or expired

Fact - Inventory Balance

Reorder Point

Reorder Point is the inventory level at storage location
that triggers a re-order for replenishment of this product

Fact - Inventory Balance

Replenishment Amount

This represents the standard re-order quantity size for
replenishment of inventory of this product (in inventory units of
measure)

Fact - Inventory Balance

Replenishment Quantity

This represents the standard re-order quantity size for
replenishment of inventory of this product (in inventory units of
measure)

Fact - Inventory Balance

Returned Amount

This is the total quantity of product returns that
currently exist (in inventory units of measure) . This quantity would
become available for use once they pass return inspection or merge into
regular product inventory

Fact - Inventory Balance

Returned Quantity

This is the total quantity of product returns that
currently exist (in inventory units of measure) . This quantity would
become available for use once they pass return inspection or merge into
regular product inventory

Kimball Matrix:

The Kimball Matrix, displaying the joins between the
facts and dimensions are provided below. The matrix helps understanding the
overall subject area in terms of which measures is analyzable by which dimension
(please see the diagram below)

Oracle EAM Analytics Dashboard

Pre-packaged content for Oracle EAM Analytics is grouped
under seven dashboard areas – KPIs, Maintenance Cost Summary, Work Order
Summary, Inventory and Costing, Quality Analysis, Resource Analysis and Asset
Genealogy.

Executive KPIs Dashboard
Page:

The Executive KPIs page provides the user a complete 360
degree view of Workorders, Maintenance Cost, Workorder Cost and other related
costs, Inventory Values, Resource efficiency and Utilization and Repair related
metrics.

Navigation: Select Asset Management Dashboard and click on
the KPI Tab.

This page contains the following reports:

Workorders Report

It contains the following KPIs:

Work Orders

Backlog %

On-Time Completion %

User can drill on to any KPI in this report to go to the Work
Order Summary page for further analysis.

Cost Report

It contains the following KPIs:

Maintenance
Cost

Preventive
Cost

Breakdown
Cost

Work Order
Cost

User can drill on to any KPI in this report to go to the
Maintenance Cost Summary page for further analysis.

Inventory Report

It contains the following KPIs:

Inventory
Value

Inventory
Quantity

User can drill on to any KPI in this report to go to the
Inventory and Costing page for further analysis.

Quality Report

It contains the following KPIs:

Mean Time Between
Failures (Days)

Failure Frequency

Mean Time to Repair
(Days)

User can drill on to
any KPI in this report to go to the Quality Analysis page for further
analysis.

Resource Report

It contains the following KPIs:

Resource
Efficiency

Resource
Utilization

User can drill on to
any KPI in this report to go to the Resource Analysis page for further
analysis.

Work Order Analysis by Plant
Report

Work Order Analysis by Plant
report displays following Columns:

Plant Name

Backlog

On-Time Completion
%

Maintenance Cost Summary
Dashboard Page

Maintenance Cost Summary page provides information about the
Maintenance Costs incurred across various Asset Groups.

Parameters: The reports in this page are analysable by the
following parameters:

Fiscal Year

Fiscal
Quarter

Fiscal
Period

Asset Group

Maintenance
Organization Name.

This page contains three reports – Maintenance Cost Details,
Breakdown & Preventive Cost Analysis and Cost Distribution.

Maintenance Cost Details
Report

The Summary report provides summary level information about
the Estimated and Actual Maintenance Cost across various Asset Groups. It
contains the following columns:

Asset Group

Estimated
Maintenance Cost

Estimated
Maintenance Cost %

Actual Maintenance
Cost

Actual Maintenance
Cost %

Variance

Variance %

Further drill on the Asset Group takes the user to
Maintenance Cost Details by Asset report which provides detailed information
about the Assets within the group and the related Costs.

Further drill on the Asset Number takes user to Maintenance
Cost Details by Workorder report which provides detailed information about the
Asset, all Work Orders executed for the asset and the related Costs and
Variances.

Breakdown Cost &
Preventive Cost Analysis Report

This report provides information on the Preventive and
Breakdown Costs across various Asset Groups. It contains the following
columns:

Asset Group

Preventive
Cost

Preventive Cost
%

·
Breakdown Cost

Breakdown Cost
%

Cost Distribution
Report

This report is generated as a pie chart where Preventive Cost
% and Breakdown Cost % is distributed across various Asset Groups. View by
Option is provided to choose Preventive Cost % and Breakdown Cost%.

Work Order Summary
Dashboard Page

The Work Order Summary page provides information about the
number of Planned and Unplanned Workorders across the Asset Group.

Parameters: The reports in this page are analysable by the
following parameters:

Fiscal Year

Fiscal Quarter

Fiscal Period

Asset Group

Maintenance Organization Name.

This dashboard page contains three reports – Work Order
Summary by Asset Group, Backlog by Asset Group, Work Order Completion by Aging
Bucket and Work Order Completion Report.

Work Order Summary by Asset
Group Report

The Summary report provides summary level information about
the number of Planned and Unplanned workorders across the Asset Group.

It contains the following columns:

Asset Group

Planned Work Orders

Unplanned Work Orders.

Further drill on the Asset Group takes the user to the Work
Order Summary by Asset report

Backlog by Asset Group
Report

The Summary report provides summary level information on
number of Backlogs, Past Due Backlogs, Backlog (%) and Past Due Backlog (%).

It contains the following columns:

Asset Group

Backlog

Backlog%

Past Due Backlog

Past Due Backlog %

Further drill on the Asset Group takes user to Backlog by
Asset Details report. .

This report can be viewed in tabular format or in graphical
format. In graphical format the report is generated as a bar chart where Backlog
(%) and Past Due Backlog (%) are plotted as Bar across Asset Group, with the
length of the bar denoting the values.

Work Order Completion by
Aging Bucket Report

Work Order Completion by Aging Bucket report provides summary
level information about the Work Orders Aging across the Asset Groups.

It contains the following columns:

Asset Group

0-5 Days

6-10 Days

11-15 Days

16-20 Days

>20 Days

Work Order Completion
Report

Work Order Completion report provides summary level
information on the Work Order Quantity, On-time Completion% across the Asset
Group.

It contains the following columns:

Asset Group

Work Order Quantity

Days Late

On – Time Completion %

Further drill on the Asset Group takes the user to Work Order
Completion Report by Asset Details.

This report can be viewed in tabular format or in graphical
format (Pareto Chart).

Inventory and Costing
Dashboard Page

Inventory and Costing page provides information on the
On-Hand Inventory details across Maintenance Organizations.

Parameters: The reports in this page are analysable by the
following parameters:

Month

Maintenance Organization Name.

This page contains two reports – On-Hand Inventory Details by
Organization, On-Hand Inventory Monthly Trend

On-Hand Inventory Details by
Organization Report

On-Hand Inventory Details by Organization report provides the
Inventory Parts Value and Inventory Parts count across Organizations.

It contains the following columns:

Organization

Inventory Parts Value

Inventory Parts #

This report can be viewed in tabular format or in graphical
format. In graphical format the report is generated as bar chart where Inventory
Parts Value and Inventory Parts # are plotted as Bar across Organization, with
the length of the bar denoting the values.

On-Hand Inventory Monthly
Trend   Report

On-Hand Inventory Monthly Trend report displays Inventory
Parts Value and Inventory Parts Count across Organizations by period.

It contains the following columns:

Month

Inventory Parts Value

Inventory Parts #

This report can be viewed in tabular format or in graphical
format. In graphical format the report is generated as line chart where
Inventory Parts # is plotted for different time periods.

Quality Analysis
Dashboard Page

The Quality Analysis Page provides information on Asset
Failures, Preventive Maintenance and Downtime for Assets.

Parameters: The reports in this page are analysable by the
following parameters:

Fiscal Year

Fiscal Quarter

Fiscal Period

Asset Group

Maintenance Organization Name.

This page contains five reports – Failure Details, Failure
Analysis by Asset Description, Down Time By Month, PMs Completion, Down Time By
Asset Group.

Failure Details
Report

This report displays the Current and Prior - Year to Date
failure costs for the asset group.

It contains the following columns:

Asset Group

Present YTD Failure Cost

Prior YTD Failure Cost

Variance

This report can be viewed in tabular format or in graphical
format. In graphical format the report is generated as bar chart where Present
YTD Failure Cost and Prior YTD Failure Cost are plotted as Bar across Asset
Group, with the length of the bar denoting the values.

Failure Analysis by Asset
Description Report

This report provides information on Mean time to repair and
Mean Time between Failures for the Assets.

It contains the following columns:

Asset Description

Asset Number

Failure Count

Mean Time Between Failure(Days)

Mean Time to Repair(Days)

This report is also generated as a pie chart where Failure
Count is distributed across various Assets.

Down Time by Month
Report

Down Time by Month report provides Monthly total down time
(in hours) for the selected time period in Graphical Format.

PMs Completion
Report

PMs Completion report provides information about the Planned
Workorder Completions over Time Period and Workorder Statuses in Graphical
Format.

Down Time By Asset Group
Report

This report provides the top 5 Monthly break ups of downtime
by Asset group.

It contains the following columns:

Asset Group

Downtime

Resource Analysis
Dashboard Page

The Resource Analysis page provides information about the
Resources being used and their utilization and efficiency.

Parameters: The reports in this page are analysable by the
following parameters:

Fiscal Year

Fiscal Quarter

Fiscal Period

Production Organization Name

Department Name

Resource Name

This page contains one report – Resource Efficiency.

Resource Efficiency
Report

The Resource Efficiency report contains the following
columns:

Resource Name

Resource Utilization

Resource Efficiency

Asset Genealogy
Dashboard Page

Asset Genealogy page provides the user with information on
the Asset, the date on which the asset was acquired, the Asset Cost and the
Maintenance Cost. In addition it also provides the Prevention cost and Unplanned
Maintenance Cost of an asset.

Parameters: The reports in this page are analysable by the
following parameters:

Fiscal Year

Fiscal Quarter

Fiscal Period

Asset Group

Asset Number

Maintenance Organization Name.

This page contains three reports – Asset Genealogy Report,
Maintenance Cost by Asset Description, and Prevention & Unplanned
Maintenance Cost by Asset Description.

Asset Genealogy
Report

This Report provides user with description of an Asset, asset
number and acquisition date of an Asset, Cost of an asset, along with
Maintenance cost, Prevention Cost and Unplanned Maintenance Cost of an
asset.

It contains the following columns:

Asset Description

Asset Number

Acquired Date

Installed Date

Expiry Date

#Years Since Installation

Asset Cost

Maintenance Cost

Prevention Cost

Unplanned Maintenance Cost

Maintenance Cost by Asset
Description report

Maintenance Cost by Asset Description report provides
information about the Maintenance Cost distribution over different Assets in
Graphical Format where Maintenance Costs are plotted as Bar across Asset
Description, with the length of the bar denoting the values.

Prevention & Unplanned
Maintenance Cost by Asset Description Report

Prevention & Unplanned Maintenance Cost by Asset
Description report provides information about the Prevention and Unplanned
Maintenance Cost distribution over different Assets in Graphical Format where
Prevention Cost and Unplanned Maintenance Cost are plotted as Bar across Asset
Description, with the length of the bar denoting the
values.