This is one of the key as mention in all previous post(1 ^[1],2 ^[2],3 ^[3]) which features of Fusion Apps, wherein the apps is leveraging BI for all reporting.As mention the key of BI in Fusion apps benefits are:

• Its going to be real-time and self-service reporting
• Can be done for Historical and complex analysis with a data warehouse
• User can get Consistent experience by providing identical tabular, graphical and visualization components used throughout the application
• Common semantic model ie Unified definition of key entities-Customer, Invoice, Date, Account, etc. and calculations
• Tight integration with Fusion Applications
  • Pervasive embedded analytics, role-based dashboards, and reports
  • Architected for Fusion Apps: seamless integration with flex, trees,security
• Easier installation, functional setups, and systems management

Fusion Reporting and Analytics

Fusion application Business Intelligence comprises of the following components.

• Oracle Transactional BI (OTBI) is real time self service reporting directly off Fusion Apps data. It has pre-packaged content covering major Fusion applications.
• Oracle BI Applications (OBIA) is a prepackaged data warehouse enabling historical analysis and cross domain insight.
• Specialized Domain specific Analytics include financial statements, sales territory planning and Project Performance built on Essbase technology. White space analysis built on Real Time decisions and Oracle Data Mining Technologies.
• Oracle BI Publisher reports are also available; these are out of box content within Fusion applications to cater to pixel perfect and highly formatted report requirements.

Fusion BI Architecture

This is three-layer architecture. Various component in Fusion BI Architecture as per below:

1.BI View Objects

• These are single source of truth for BI
• Represent facts and dimensions
• Apps data security been implement at this level.

2.BI Common Semantic Model

Supports highly aggregated trending and real-time transaction listings from a single query model

• Single RPD with one Business Model
• Single Business Column and Entity shared across OTBI and Oracle Business Intelligence Application (OBIA)
• Common Conformed Dimensions ensure cross fact , cross subject areas and federated OTBI/OBIA reporting

3.Oracle BI Applications (OBIA)

As mention is used for unlimited historical analysis - trending and cross-domain insight Pre-packaged DW, ETL, metrics, and interactive dashboards .

4.Oracle Transactional Business Intelligence (OTBI)

• Real time window into the transactional System where business users can create their own reports using prepackaged functional metadata
• Co located & semantically integrated with the Data Warehousing metadata
• Reads security, flex fields and trees from Fusion Applications
• Reports / charts from OTBI can be embedded into Fusion Applications

OTBI and OBAI Vis -a-Vis

These two can be understood differently, here are the compare for these two.

Hope this post helps you to understand the BI in term of fusion.

Other Fusion Post

• Fusion’s Functional Setup Manager ^[4]
• Oracle Fusion Supply Chain Management – A Brief Overview ^[5]
• Oracle Fusion Procurement ^[2]
• Oracle Fusion Project Portfolio Management ^[3]
• Oracle Fusion Financials Application ^[1]
• Oracle Fusion and Oracle Fusion Applications : Overview ^[6]

1 Comment To "BI in Oracle’s Fusion Applications : An Quick Overview"

#1 Pingback By Oracle’s Co-Existence Strategy | OracleApps Epicenter On March 25, 2011 @ 2:58 am