No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle Essbase vs Oracle OBIEE comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Oracle Essbase
Average Rating
8.2
Reviews Sentiment
4.6
Number of Reviews
18
Ranking in other categories
Database Development and Management (11th)
Oracle OBIEE
Average Rating
7.8
Reviews Sentiment
5.7
Number of Reviews
159
Ranking in other categories
BI (Business Intelligence) Tools (12th), Reporting (8th)
 

Mindshare comparison

Oracle Essbase and Oracle OBIEE aren’t in the same category and serve different purposes. Oracle Essbase is designed for Database Development and Management and holds a mindshare of 1.2%, up 1.1% compared to last year.
Oracle OBIEE, on the other hand, focuses on BI (Business Intelligence) Tools, holds 1.3% mindshare, down 3.8% since last year.
Database Development and Management Mindshare Distribution
ProductMindshare (%)
Oracle Essbase1.2%
Redgate SQL Toolbelt Essentials4.5%
Spotlight4.0%
Other90.3%
Database Development and Management
BI (Business Intelligence) Tools Mindshare Distribution
ProductMindshare (%)
Oracle OBIEE1.3%
Microsoft Power BI9.3%
Tableau Enterprise6.7%
Other82.7%
BI (Business Intelligence) Tools
 

Featured Reviews

Bhavya N - PeerSpot reviewer
Senior System Engineer at Infosys
Ensuring efficient data analysis and reporting while identifying areas for calculation and export improvements
The features of Oracle Essbase are valuable, such as its multi-dimensional database used for dynamic calculations and reporting purposes. These features are valuable because they support multi-dimensional data views, allowing users to analyze relationships across various data categories and establish a comprehensive perspective on business operations. Moreover, dynamic calculations allow real-time data analysis, significantly improving the accuracy and depth of financial insights. I have utilized Essbase's data aggregation capabilities. The Oracle Essbase interface provides a good user experience, allowing users to easily navigate and analyze data with fast query performance, effective data visualization tools such as charts, graphs, and tables, and flexibility for customizable analysis and reporting, including the ability to create ad hoc reports. The benefits of the interface include improving productivity and enhancing decision-making.
AA
Analyst at Equifax Inc.
Unified semantic layer has driven informed credit risk decisions and real-time analytical insight
Performance-related issues are a concern, as in multiple reports I have seen, some reports were poorly performing. We can focus on implementation of performance so that reports are delivered within seconds. The user interface and self-service experience can be improved through modernization of the UI, addressing self-service limitations, and integrating with mobile. Technical and administrative complexities can also be addressed. Complexities such as system configuration require attention. In the initial setup of Oracle OBIEE, there are multiple things starting from infrastructure provisioning, database schemas, and WebLogic server installations. However, the RPD, the semantic layer, is the steepest hurdle. Security integration, integrating with LDAP or Active Directory, is rarely plug and play and requires deep knowledge of WebLogic. Deep knowledge is necessary when starting with the initial setup of Oracle OBIEE. Other dependencies include Java middleware and client tools. Since Oracle OBIEE deals with huge data, report performance is the biggest concern. The out-of-the-box setup is rarely optimized, so we need to manually check configuration files, such as nqsconfig.ini file settings. For recommendations in Oracle OBIEE, from what I have seen, we work with star schemas in the RPD. I always aim for the star schema in the business model, even if the physical source is normalized. This approach will impact the performance, speed of the data, and accuracy. Oracle OBIEE could improve to allow other schemas as well. Performance is a major area for improvement, and they should work on aggregating the persistence and improve the persistence wizard where we implement aggregations. Caching features have been given, including event polling tables where we can do purging and seeding, but the main focus should be with respect to schema designs.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data."
"Essbase is a powerful tool that continues to provide value for companies."
"I have found the most valuable aspect is the user-friendly environment and current features."
"Oracle's capability to define custom hierarchies and dimensions has helped my organization in performing nuanced data exploration and advanced modeling because we use Oracle Essbase for dimension definition and also to define the properties of these members, such as dynamic members, stored members, shared members."
"Essbase is extremely stable and low-maintenance."
"Essbase is a multidimensional database (MOLAP) is undoubtedly leading in that space."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"The solution is scalable."
"Oracle OBIEE improves our day-to-day, but it is not a very user-friendly tool, according to some of our users."
"I have been using the solution for quite awhile and, in line with what is reported in the media, I would recommend it to others."
"It has a robust way in which it manages the humongous amount of data and reporting while recording, and it’s phenomenal."
"It has a lot workaround in order to do the report. data blending, and getting information from big data sources."
"Oracle Business EE has a futuristic vision for BI Server capabilities with support for answers, flexible dynamic dashboard, intelligent untime query engine, web and mobile analytics and support for structured and unstructured data."
"The scalability of the product is good."
"The scalability of the product is good."
"It has given clients visibility into their operations from a holistic viewpoint."
 

Cons

"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The ability to drive external reporting out for development could be improved."
"Sometimes, the current program is slow. They may have to consider the storage and the RAM, increasing the speed and performing the queries at a faster speed."
"Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good."
"The main concern is that Oracle is ending on-premises server support, so it would be better if there was a cloud platform available for Oracle Essbase."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"I would like to see an integration with application performance management and a version control management tool."
"The ability to drive external reporting out for development could be improved."
"The pricing of the solution should be bettered."
"We still have a lot of security issues that need to be resolved, so we don't know."
"If you have a lot of Oracle products, they would conflict if they are running the same box due to code names, code numbers, and pretty much use the same numbers."
"Designing and building the entire set up of Data Warehousing and Dashboard Reporting implementation has been challenging in terms of resources and time."
"Oracle OBIEEE's performance and licensing costs could be improved."
"Pricing is an area that could be improved."
"Clustering and security (SSL, SSO, etc) can be tough at times."
"They can always improve on the user interface, and the publisher could get some new features."
 

Pricing and Cost Advice

"The solution is expensive."
"It is a costly solution."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"It's comparable to the current technology we're using, Qlik Sense."
"There are no additional costs, but there might be some charges for the Java feature."
"This is a very costly product."
"In our organization, we use a user-based license for Oracle OBIEE, and I've heard that the license cost is based on the number of users."
"The licensing cost is based on the number of users using it."
"All products from Oracle are very pricey."
"A person only needs to pay towards the subscription costs since it is a cloud-based solution. I use the free version of Oracle OBIEE."
"Its licensing is yearly."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
885,444 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Senior Manager - BI Head with 5,001-10,000 employees
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
7%
Insurance Company
7%
Retailer
5%
Financial Services Firm
14%
Government
10%
Manufacturing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise1
Large Enterprise14
By reviewers
Company SizeCount
Small Business40
Midsize Enterprise34
Large Enterprise103
 

Questions from the Community

What is your experience regarding pricing and costs for Oracle Essbase?
It's not that expensive, but also not cheap. I'm not sure because it's a private license.
What needs improvement with Oracle Essbase?
A significant area for improvement in Oracle Essbase is that financial statement analysis, CAPEX and OPEX analysis, and financial consolidation must be done manually, as Oracle Essbase doesn't incl...
What is your primary use case for Oracle Essbase?
The initial setup of Oracle Essbase is dependent on whether you select BSO or ASO cubes. First, you need to set up the type of information and once the type of cubes is defined, you need to define ...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
Which Oracle product is better - OBIEE or Analytics Cloud?
Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist customers. These are two attributes that make this system quite valuable. OB...
What do you like most about Oracle OBIEE?
The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand.
 

Also Known As

Essbase
OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
 

Overview

 

Sample Customers

CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
Find out what your peers are saying about Nutanix, Quest Software, Oracle and others in Database Development and Management. Updated: March 2026.
885,444 professionals have used our research since 2012.