Friday, May 24, 2024


Fusion report Or OBIEE (Oracle Business Inteligence enterprise edition) is divided into 2 sections:

  1. BIP( Business Inteligence publisher)
    1. SQL Query >> Data Model >>select required columns >> Layout >> Run >> Output
  2. OTBI (Oracle Transactional Business Inteligence)
    1. Subject Area >>  Select Columns >> Layout >> Run >> Output 


  • Oracle Business Intelligence Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence throughout an organization. 
  • BI Publisher can be used as an alternative reporting solution to OTBI. Some of the data sources available are SQL Query, XML, HCM Extract, and View Object (brought in through web service, ADPI, etc.). 
  •  BI Publisher works as an enterprise reporting solution for authoring, managing, and delivering reports from multiple data sources in multiple formats through multiple channels (E.g., checks, invoices, remittance, etc.). Utilize BI Publisher for writing your own SQL query, formatting reports, joining historical data with real-time information, and report bursting. Typical end users include Technical Human Resource Information System (HRIS) and IT Developers.


  • OTBI provides a flexible and easy to use analysis tool that helps to gain real-time insight into transactional data.
  • OTBI is aimed at business users and especially shines when the report creator is someone who does not know SQL and/or the underlying table structures. 
  • OTBI’s core functionality allows users to simply drag and drop selected data from subject areas and use different graphical views. Data can be filtered, drill-down can be enabled, and action links can be created. Reports or dashboards can be scheduled for delivery and reports can be exported to Excel, Word, and other formats. A reporting wizard (BI Composer) is available to guide casual business users through a few simple steps to run, edit or create OTBI reports and queries. 
  • Typical end users include Financial Analysts, Compensation Analysts, Benefit Analysts, and Human Resources Analysts.


  1. For BIP: Manual SQL we can write, but In OTBI: No SQL needed, drag and drop interface,subject Areas available.
  2. For BIP: its more technical where as for OTBI: functional and technical both can develop
  3. For BIP: thousands of tables, joins needed but for OTBI: presentation layer developed so user does not need to join different tables together.
  4. For BIP: reports can takr very long time to build where as in OTBI: relatively quick build.
  5. For BIP: can get at almost all needed fields and information but in OTBI: not all fields are available in subject areas.
  6. For BIP: we can use multiple report formats but for OTBI: restricted number of formats.
See the table below for more differences:

Advantages of OTBI over BIP:
  1. Functional consultant can build the OTBI report.
  2. Oracle has already provided pre build subject areas.
  3. We cab build the otbi report for scm, crm finance etc.
  4. We can creatw the dashboard using OTBI
DIsadvantages of OTBI over BIP:
  1. We cant do custom report
  2. We cant build any custom subject areas.


No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...