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

« Oracle Project Manufacturing - A complete solution for Project Manufacturing based industries (Project Procurement) | Main | Face of the CRM Apps: Part III »

What to Choose? OBIEE or BIP- When in Confusion use Comparison

Guest blog by
Neeraj Jha, Principal Consultant, Infosys Limited

While making an investment into Business Intelligence (BI), an organization wants to make best use of the technology available. Lack of technical capability / understanding of functionality provided by BI tools, would most likely lead to use of wrong tool and meet the needs only partially or inefficiently. In this blog, I would like to talk about the key functionalities that OBIEE or BIP can provide and pointers that will help to decide whether one should use OBIEE (Oracle Business Intelligence Enterprise Edition)  or BIP (Oracle Business Intelligence Publisher). 

Using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g one can deliver the most vigorous set of reporting, dashboard and scorecard functionality. It provides rich end-user experience and is easier for adhoc query and analysis. There are many key features of OBIEE 11g e.g. Map visualization, integrated search, actionable data that can be used by organizations effectively. OBIEE 11g supports the highest workloads and complex deployments as is built on a modern technological foundation. The total cost of ownership for an enterprise is overall low.

If you are looking for a single, Web-based platform for authoring, managing, delivering interactive reports and dashboards, Oracle Business Intelligence Publisher (BI Publisher) is the right pick. It allows formatted documents completely of all types. Using Oracle's Business Intelligence Publisher, report layouts can be designed by end users in a Web browser. This reduces the time and cost needed to develop and maintain reports.BI Publisher is highly scalable and extremely efficient and can generate tens of thousands of documents per hour having minimum impact on transactional systems.

High level classification criteria that should be used for decision making whether a report should be built using OBIEE or BIP for effective use of tools available are listed below :

Matrix for categorizing in OBIEE/ BI Publisher Report:


BI Publisher


If the Report needs Analysis / Historical Analysis, is Analytical in nature



If the Report is Static in nature and is needed in Real time



If the Report is needed for Operational Reporting with some lag



If the Report is Operational in nature and expected with no lag



If the Report needs to show some trends



If the Report is Static in natures 



If the Report needs graphs



If the Report is having fixed formats



If the Report needs drill down



If the Report needs Pixel Perfect Formats and complex layouts



If the Report is expected to show aggregated data



If the  Report is Transactional in nature and needs to be prepared Real time



If the Report is dynamic in nature



Ad-hoc Reporting is needed



While there are no set rules for selecting the tool for Business Intelligence Reporting, above criteria aids in deciding which tool will help using the best available functionality from OBIEE / BIP.


Hi, thanks for making such a good comparison between both technologies.I would also like to share my views:
Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.

Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.

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

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