Try our new research platform with insights from 80,000+ expert users

Oracle Essbase vs SAP BusinessObjects Business Intelligence Platform 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.4
Reviews Sentiment
5.5
Number of Reviews
14
Ranking in other categories
Database Development and Management (12th)
SAP BusinessObjects Busines...
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
107
Ranking in other categories
BI (Business Intelligence) Tools (5th)
 

Mindshare comparison

Oracle Essbase and SAP BusinessObjects Business Intelligence Platform 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.0%, up 0.9% compared to last year.
SAP BusinessObjects Business Intelligence Platform, on the other hand, focuses on BI (Business Intelligence) Tools, holds 3.7% mindshare, down 5.3% since last year.
Database Development and Management
BI (Business Intelligence) Tools
 

Featured Reviews

RANOJOY PAUL - PeerSpot reviewer
Stores multidimensional data, good customer support and interface is very easy
It is very fast compared to other normal databases, like SQL and MySQL. It doesn't store data in tables in the back end. To load data into Essbase, we need to prepare it in a table format. When we find the data in the table, we need to verify it. This way, you can rate the data. But Essbase stores multidimensional data. We have dimensions, which means the data belongs to some company or some time period. For example, if you work for three years, your salary should be something. In this way, we prepare top-level members called dimensions. The dimension defines your position, the year, and the section you were working in the company. We get an intersection of all these dimensions for certain data, and fetching that data is very fast in Essbase compared to normal SQL. If you store this data in a normal SQL table, you need to prepare a row with your company name, employee name, employee ID, joining date, and everything, and then you need to push it into a SQL table. You can search it using your query, but here, that thing is different. Here, you can collect data using forms, reports, and we use a Microsoft tool, which is an add-in called Smart View. Using that, you would just take that data. Here, you need to just create an integration of all these dimensions, and then only you can find the data.
Declan Dempsey - PeerSpot reviewer
Provides efficient data reporting while needing easier deployment and improved interface
Users tend to put everything into Excel, though I try to discourage this. The best feature about it for me, and for them, is the fact that you have a universe that is well made. This means you don't have those months that get assigned. You can just get to the point and get a report very quickly. Unfortunately, in some ways, it's a double-edged sword because it becomes more of a self-service ETL, even for the reporting team. If you have a decent universe and you just want to quickly get something together, it's very usable. Compared to Click, you can drop those reports very quickly.

Quotes from Members

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

Pros

"It is very fast compared to other normal databases, like SQL and MySQL."
"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."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It helps us fetch specific data sets per users' requirements."
"I have found the most valuable aspect is the user-friendly environment and current features."
"Oracle Essbase is a web integration system that integrates with other data systems."
"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 can handle a large volume of data."
"The features which the solution has been awesome. The way the data is fetched from the database, and the queries are executed, is unique using the Universe of Business Objects. That makes it unique and we could not find another solution that functions in a similar way. It's has a great way of receiving and executing queries."
"I rate SAP BusinessObjects Business Intelligence Platform an eight out of ten."
"Ease of report development is a key feature."
"The web intelligence reporting tool and universe designer are the most valuable aspects of the solution."
"It has been extremely valuable, to combine data from various data sources."
"It gives you a lot of flexibility in designing your dashboards."
"The solution's user security is extremely effective. You can profile very well. All the users and all the functionality is protected and that includes information and data segregation."
"We are using SAP BusinessObjects because its scheduling capabilities are more powerful than those of other tools."
 

Cons

"The initial setup is pretty complex."
"I would like to see an integration with application performance management and a version control management tool."
"It's an expensive product to use."
"The initial setup could be simplified."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"There is room for improvement in terms of cost-effectiveness."
"They should improve the solution's performance."
"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 cost of this product, so every company is not suitable to use it. Because of the very huge amount of integrations, every organization can not use it."
"The solution is not good for self-services, they can improve in this area."
"The SAP BusinessObjects Business Intelligence Platform has always struggled with dashboarding."
"I don't like the fact that I have to use two tools. Web Intelligence is good for reporting and all kinds of stuff, but I would rather have one product. All the reporting features of Web Intelligence should be developed within Lumira. A lot of predictive abilities have been brought into the cloud version of SAP Analytics. It would be nice to see a lot of newer technologies and AI. Predictive capabilities are becoming a little more standard. Instead of having to get another model, we are just looking for one solution to deal with analytics including predictive."
"I really want SAP to focus on the dashboarding side. Based on what I have seen in the past 10 years, dashboarding has captured a lot of markets. Executives at the top-level want data that is summarized, looks good, and tells you a story. That's where Tableau, Qlik, and Power BI have an upper edge. It doesn't mean SAP doesn't give you dashboarding. They do have a dashboarding solution, but Tableau, Qlik, and Power BI are more intuitive and more attractive. I would like SAP to capture the dashboarding market as well, wherein they give at least some competition to other competitors. Presently, Tableau, Qlik, and Power BI are leading the market."
"Recently, it's become less stable if I am working on Citrix."
"The dashboard tool is called Lumira and it is very uncomfortable for developers to use. They should improve this in the future."
"Currently, we can use Explore to do data discovering, but cannot generate charts."
 

Pricing and Cost Advice

"The solution is expensive."
"I believe the licensing is on a monthly base."
"It is a costly solution."
"Essbase is competitively priced."
"​It is not an expensive platform. The licensing is for a package of users starting at 10 users."
"We are satisfied with the solution, but we are not satisfied with the licensing cost which SAP offers. They offer one lumpsum licensing which does everything. That is not the right strategy, because sometimes you don't have power users, they are only viewers, but we need to buy the full license for them. This is not something we want to continue with."
"SAP BusinessObjects Business Intelligence Platform is an expensive application."
"It is not a subscription model, but you must purchase a perpetual license for this."
"We purchase licenses through Epic. So, we get an Epic price as opposed to the SAP price. If we were going to use other products like Webby that they offer or exclusively use BI Launch Pad, it would cost a lot because half of our employees would touch it in some fashion. So, we use Epic-Crystal integration to keep the licensing cost down. I believe the BI Launch Pad licensing is something like $800 for each, and the Crystal Report licensing is something like $500 for each, but that's not what we pay."
"Its price is fair."
"Just work with SAP to make sure you have enough licenses but don't go overboard."
"It is not cost-effective. It is expensive."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
851,604 professionals have used our research since 2012.
 

Comparison Review

it_user6663 - PeerSpot reviewer
May 25, 2013
SAP Business Objects vs. Microsoft BI
A quick look at the whole idea on another weblogs gives you a sense that all of them just talked about very brief things like report refresh feature in BO or cube feature in MS Analysis Service. I choose MS BI and I want to share my reasons and opinions on why I choose it and give you another quick…
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Computer Software Company
11%
Insurance Company
7%
Manufacturing Company
7%
Financial Services Firm
15%
Computer Software Company
11%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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?
If I got the opportunity to work with Hyperion, which is the best product, I would definitely go with that. The main concern is that Oracle is ending on-premises server support, so it would be bett...
What is your primary use case for Oracle Essbase?
We provide complete ownership of this application to Walmart projects. In the UK system, we support and develop for the Asda account, known as Eltham. We provide installation and support to over 50...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it consta...
What do you like most about SAP BusinessObjects Business Intelligence Platform?
What I like the most about SAP BusinessObjects BI Platform is that it has significantly improved our decision-making process.
 

Also Known As

Essbase
SAP BusinessObjects BI Platform, SAP BusinessObjects, Business Objects
 

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.
SRAM, Kennametal, Fairfax Water, British American Tobacco, Velux, and FedEx.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management. Updated: May 2025.
851,604 professionals have used our research since 2012.