Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Manage Projects by Exception Using Fusion Project Portfolio Management | Main | Unlocking the Organizational Change Conundrum »

Fusion BI Apps and Oracle Transactional Business Intelligence

Introduction to Fusion BI Apps and Fusion Reporting

Fusion Business Intelligence Applications is an Out-Of-The-Box reporting solution that comes packaged with Fusion Applications having pre-built data models, Extract-Transform-Load processes, Key Performance Indicator's, Metrics, Reports and Dashboards. They cover varied business functions viz.

  • Oracle Procurement & Spend
  • Oracle CRM
  • Oracle SCM
  • Oracle Financials
  • Oracle HCM
  • Oracle Project Portfolio Management

Closely integrating the reporting solution for Oracle Fusion with the transactional systems it provides seamless interaction of reports in Fusion transactional screens. This provides a common platform and also allows the triggering of business workflows from the reporting application.

The components comprising Fusion Application Business Intelligence are as follows

  • Oracle Transactional Business Intelligence - real time self-service reporting tool sitting directly on Fusion Apps data
  • Oracle Business Intelligence Applications - pre-built data warehouse enabling historical analysis and deep-dive into specific business areas with strategic insights
  • Specialized Domain specific Analytics package - built on Essbase technology which includes financial statements, Project Performance and sales territory planning
  • Oracle Business Intelligence Publisher - catering to pixel perfect and highly formatted reporting requirements within Fusion applications

Oracle Transactional Business Intelligence

Built on ADF and OBIEE technology, OTBI is a new component for online analytical reporting provided with the Fusion Edition. From a reporting perspective OTBI allows for the expansion of coverage providing new KPIs, reports and dashboards. OTBI provides a real time window into the transactional systems where business users can create their own reports using pre-built functional metadata.

OTBI vs OBIA: At A Glance

Any organization wants the best return on their investments and so is true for an organization while making an investment into BI. The lack of understanding of functionality provided by BI tools and limited technical capability generally leads to misguided investments and question marks over the effectiveness of the BI infrastructure. Some key areas one needs to look into while deciding whether to use OTBI or OBIA for the organizational reporting needs are discussed below.

OTBI and OBIA use conformed dimensions based on a single common semantic data model. While looking at a solution to a business problem we first need to ascertain whether it would employ analysis of historical data or whether the current state analysis of transactional data would be enough. If the former is true, OBIA is the preferred way to go whereas OTBI fits right in for the latter scenario. Another key aspect is the actual business process requirement from the reporting platform. OTBI is preferred by Operational users for tactical reporting while OBIA for strategic reporting by Managers and Analysts. OTBI on the one hand enables real-time reporting providing data views at the minutest level with no data movement involved while OBIA on the other is based on a data warehouse model with using an ETL tool for data loads with the data availability being determined by the frequency of the ETL refresh.

Although there are no standard rules for selecting the perfect Business Intelligence reporting tool for an organization, the criteria's discussed above certainly do help in deciding the best fit.


This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,packaged applications,business applications, Web services,
Business intelligence, Business Development, Software Development etc.

Thanks for sharing these information. It’s a very nice topic.

Thanks for sharing these information. It’s a very nice topic.

This is really an informative article. For the ones that want to categorise programming, healthcare, inventory management, oracle transactional business intelligence, etc., this post can help them and enable them to deliver high quality services.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles