Skip to main content


Oracle Transactional BI: OTBI vs OTBIE


At Collaborate 16, Pawan Kumar from Perficient presents the key characteristics that benefit adopters of Oracle Transactional Business Intelligence (OTBI) and Oracle Transactional Business Intelligence Enterprise (OTBI-E). Below are the main points I am highlighting from Pawan’s session that help differentiate between the two products and shed some light on how each product is most useful.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

OTBI enables real-time reporting on Oracle Fusion Applications by leveraging web services to communicate with OLTP systems via ADF Entity and View Objects. In addition, OTBI offers tight security integration with the corresponding Oracle Fusion Application. With OTBI, there is no need to worry about customizing the reporting layer whenever new columns are customized in the transaction system as OTBI already supports automatic key and descriptive flex fields extension.

Here is where OTBI requires special attention:

  • Cross Subject Area Reporting while possible is not highly recommended. Such analysis require caution as they tend to be performance intensive.
  • Querying large volumes of data doesn’t perform well without incorporating effective selective filters.
  • Maintain custom content in custom folders to avoid overriding custom content when an OTBI upgrade happens from Oracle.
  • Avoid chaining of reports together by filtering on other reports and instead use the set operator to filter reports.
  • OTBI provides real-time analytical capability for the current state of the business based on the latest and greatest information from the transaction system. However, it falls short when we start talking about historical snapshots of data, trending of KPIs, and tracking changes over time. For such, time-aware reporting, OTBIE is the solution of choice.2016-04-14 10.10.25

OTBI-E is a Cloud based offering from oracle for multi-source system analytics. This is similar to the on-premises Oracle BI Application but in the Cloud. Unlike OTBI which is restricted to the single application that accompanies it, OTBI-E is aimed at loading data from numerous cloud and on premise sources. With OTBI-E, adopters do not need to do any development or configuration to get pre-built dashboards. OTBI-E includes real-time reporting on Oracle Cloud sources like HCM, Finance and Sales applications. As with OTBI, OTBI-E also has automatic extension of flexfields. Moreover, OTBI-E supports loading data from external non-Oracle applications using the Universal Adapter.

The following highlights the main difference between OTBI and OTBI-E.

2016-04-14 10.05.58

Thoughts on “Oracle Transactional BI: OTBI vs OTBIE”

  1. BI Cloud Service (BICS) is the BI platform (alone). BICS doesn’t include pre-built applications like OTBI or OTBI-E. If an organization already has OTBI-E, that means they already have both the BI platform and the pre-built content for Oracle Applications. If a company has several Oracle Cloud Apps, OTBI-E may be a better option than BICS since it includes pre-built content (Reports/Dashboards/Data Model/Data integration). If the company’s data includes some non-Oracle applications, BICS is likely to be a better fit.

  2. OTBI-E comes with an analytic data warehouse in the cloud, (OBAW). Data is loaded in OBAW from Oracle cloud Apps. Question: what ETL tool is used to load data into OBAW ? Is it still ODI ?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Mazen Manasseh, Director of Business Analytics

Mazen is a Director of Business Analytics at Perficient and an accomplished professional services leader with 20 years of being a customer advocate. An analytics solutions delivery expert in functional domains covering Supply Chain, Financials, HCM, Projects and Customer Experience. Being a thought leader in the business analytics space, he conducted numerous business training sessions and spoke at technology conferences around analytics and machine learning.

More from this Author

Follow Us