Fusion Applications – Overview of Business Intelligence and Reporting components
Posted by sranka on February 8, 2012
While looking through Oracle Support came across an informative “Overview of Business Intelligence and Reporting components”
Fusion Applications includes a variety of Business Intelligence and Report functionality. Some of these are exposed to the end-user, and some exist as middleware layers.
This document briefly lists the components, their common acronyms and the functionality that they bring to Fusion Applications.
Please note that the column titled “Function” contrass whether the component is a tool (infrastructure), or content (an analysis or report definition which is delivered with Fusion Apps).
|BI Component||Function||Description||Where exposed in the Applications UI (example)|
|Oracle BI Enterprise Edition (OBIEE)||Middleware Tools and infrastructure||Oracle BI Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure that includes a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards infrastructure, proactive intelligence and alerts functionality, and an enterprise reporting engine. Underlies most BI analyses and reports.||N/A|
|Analysis Editor||Ad-hoc analysis designer||The “Analysis Editor” (or Answers) lets you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can include the views that you create in an analysis, for display in Fusion Apps pages or dashboards. A sub-component of OBIEE.||Via Reporting Pane or Navigator: Tools|
|Essbase||Middleware Tools and infrastructure||Oracle Essbase is an online analytical processing (OLAP) server that provides an environment for deploying prepackaged applications or developing custom analytic and enterprise performance management applications. Example usage: underlies Financial Reporting.||Financials > GL|
|BI Composer||Ad-hoc analysis designer||BI Composer is a simple-to-use wizard that allows you to quickly and easily create, edit, or view analyses without the complexities of the Analysis Editor. A sub-component of OBIEE.||Via Reporting Pane or Navigator: Tools|
|Oracle Transactional Business Intelligence (OTBI)||Analyses||Oracle Transactional Business Intelligence is a complete, prebuilt BI solution that deliver intuitive, role-based intelligence throughout an organization. It uses Oracle BI Enterprise Edition as it’s technology layer to provide an easy-to-use interface for business users to perform current state analysis of their business applications.
Pre-constructed queries and reports are executed real time against the transactional schema supported by a layer of view objects.
An OBIEE repository (.rpd) and Web Catalog are supplied.
|CRM Sales Opportunity Watch Real Time|
|Oracle Business Intelligence Applications (OBIA)||Analyses||Oracle Business Intelligence Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence throughout an organization.
Oracle Business Intelligence Applications analyses use a data warehouse. Oracle Business Intelligence Applications supplies the warehouse database schema and the logic that extracts data from the Oracle Fusion Applications transactional database and loads it to the warehouse. Oracle Fusion Applications end users interact with the information in the Oracle Business Analytics Warehouse via analyses exposed on Fusion Applications pages, also using Oracle BI Enterprise Edition components (such as Analysis Editor, BI Composer and Dashboards).
Datawarehouse Console (DAC) is used to control and orchestrate extract-transform-load (ETL).
Informatica PowerCenter ETL tool is a third-party ETL platform (available from eDelivery) that performs the detailed extract, transform, and load (ETL) operations for the data warehouse.
An OBIEE repository (.rpd), Web Catalog, DAC repository and Informatica respository are supplied.
|Financials > Customer Profitability|
|Financial Reporting||Reports||Oracle Hyperion Financial Reporting (Financial Reporting) is a powerful tool for designing and presenting analytic data graphically. You can design traditional financial report formats such as cash management reports, profit and loss statements, and balance sheets. You can also design nontraditional formats for financial or analytic data that include text and graphics.
Use Financial Reporting to create and deliver financial reports to the General Ledger system. Reporting administrators use EPM Workspace with financial reports to create and modify reports, books, and batch definitions and to schedule batch jobs via the reporting scheduler user interface within EPM Workspace. Reporting users run and view reports using the General Ledger user interface; they can launch reports in an IFrame within the General Ledger browser window.
|Financials – Financial and Statutory Reporting|
|BI Publisher (BIP)||Middleware Tools and infrastructure||WYSWIG Tool for creating pixel precision reports.
Oracle Business Intelligence Publisher is an enterprise reporting tool for authoring, managing, and delivering reports from multiple data sources in multiple formats through multiple channels. A sub-component of OBIEE.
|Via Reporting Pane or Navigator: Tools|
|BIP Reports||Reports||Pre-constructed pixel perfect formatted reports||Fusion Financials contains over 100 pre-constructed BIP reports, for example. 1099 report|
|Oracle Real-Time Decisions (RTD)||Middleware Tools and infrastructure||Oracle Real-Time Decisions enables you to develop adaptive enterprise software solutions. These adaptive solutions continuously learn from business process transactions while they execute and optimize each transaction, in real time, by way of rules and predictive models. A sub-component of OBIEE.||N/A|
|RTD Reports/Content/CRM Sales Predictor||Analyses||CRM Sales Prospector|
|Oracle Data Miner (ODM)||Middleware Tools and infrastructure||Oracle Data Mining automatically finds relationships hidden in data, by expanding SQL it adds analytical verbs–such as predict, cluster, detect, and classify–also by embedding cutting-edge algorithms in the Oracle Database kernel. Underlies CRM Sales Predictor.||N/A|
|ADF based Reporting||Reports||Reports and Graphs which use ADF objects to create the UI look and feel , where the data has been sourced from Oracle Business Intelligence. These use an ADF component called BI Logical SQL VO, which in essence is a special type of VO that executes a logical SQL statement against the BI server. These VO’s are referenced in the .rpd ( BI’s common semantic layer)
Note that there are some ADF based graphs and reports which do not use BI as a source for data.
The above entire text has been taken from oracle support document [ID 1334765.1]
Hope this helps
Sunil S Ranka
“Superior BI is the antidote to Business Failure”