Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

BI in Oracle’s Fusion Applications : An Quick Overview

Posted on March 21st, 2011 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

This is one of the key as mention in all previous post(1,2,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

dgreybarrow 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.

dgreybarrowFusion BI Architecture

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

Fusion BI Architecture

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


dgreybarrow OTBI and OBAI Vis -a-Vis

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

Fusion BI compare

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

dgreybarrowOther Fusion Post

Related Posts

Posted in Fusion Application | 1 Comment »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. Oracle’s Co-Existence Strategy | OracleApps Epicenter Says:

    […] Co-Existence StrategyBI in Oracle’s Fusion Applications : An Quick OverviewFusion’s Functional Setup ManagerOracle Fusion Supply Chain Management – A Brief […]

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.