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.3
Number of Reviews
103
Ranking in other categories
BI (Business Intelligence) Tools (6th)
 

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.8% 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.
Sumeet  Zalpuri - PeerSpot reviewer
Fully integrated enterprise-level tool
The initial setup was not straightforward. Since it is a complete enterprise tool, it needs a certain level of expertise to set up the SAP BusinessObjects Business Intelligence Platform. There are a lot of steps involved. You need to get the user accepted and you need to validate the data. So you need to understand the architecture of the application. I would rate the initial setup as moderate since it's not very easy or much difficult. For a small enterprise, the installation would take one day. You must ensure you are on a supported platform like Windows or Linux and if your database is not on the server but in a different zone of the network, you need to ensure connectivity. You must also ensure the SAP BusinessObjects Business Intelligence Platform supports your organization's browser. These are the major things that must be taken care of before the installation. Around 500 users are using the SAP BusinessObjects Business Intelligence Platform in my company. We are a team of around eight technical people involved in the deployment and maintenance of the SAP BusinessObjects Business Intelligence Platform. If you run a SAP shop with ECC, the best solution is the SAP BusinessObjects Business Intelligence Platform because it's tightly integrated. You'll get lots of offers from SAP when it comes to licensing. So there's an advantage. But if you are not a SAP shop, the licensing becomes a hindrance. So if you have SAP as a source, then I recommend people to go with SAP BusinessObjects Business Intelligence Platform as it's a tool that works wonders. I have been working on POCs where we use SAP data for BI, which was a nightmare. So if you have ECC and SAP in the back end, go with the SAP BusinessObjects Business Intelligence Platform. If you have any other tools in the back end, then try to negotiate and see the use case.

Quotes from Members

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

Pros

"Essbase is extremely stable and low-maintenance."
"It helps us fetch specific data sets per users' requirements."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"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."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is scalable."
"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."
"The solution can handle a large volume of data."
"It is solid and stable."
"​It is a very good product, stable, and has good technical capabilities.​"
"This reporting and broadcasting solution has a lot of flexibilities and can connect to multiple source systems."
"It allows the analysis of business data and enables decisions based on the analysis."
"What I like the most about SAP BusinessObjects BI Platform is that it has significantly improved our decision-making process."
"It has been extremely valuable, to combine data from various data sources."
"The initial setup of SAP BusinessObjects Business Intelligence Platform was easy since the solution is user-friendly."
"The Dynamic HTML (DHTML) client option of Webi has been enhanced adding features that were previously only available with the Java client including conditional formatting and support of XLS as a data provider."
 

Cons

"The initial setup is pretty complex."
"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."
"It's an expensive product to use."
"I would like to see an integration with application performance management and a version control management tool."
"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."
"There is room for improvement in terms of cost-effectiveness."
"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."
"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."
"The biggest area for improvement would be the dashboarding capabilities due to the recent change from Xcelsius to Dashboard Designer. This has created a gigantic ripple in many companies because the skill sets required are drastically different."
"Technical support may not always be timely or effective."
"Integrations with things like Active Directory and LDAP tend to be a little complex."
"The admin features for disk space management need work. It's very difficult to manage the disk space by the application; good admin features and not included to allow you to do that. I don't believe that is in the latest version of the product either."
"Over the years, the product tends to rename and rebrand itself and change its direction. This is a deficit of the solution."
"There is room for improvement in providing more user-friendly and versatile reporting options."
"Recently, it's become less stable if I am working on Citrix."
 

Pricing and Cost Advice

"The solution is expensive."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"It is a costly solution."
"Just work with SAP to make sure you have enough licenses but don't go overboard."
"Depending on your size, try to stick with SAP BusinessObjects BI Edge. Most people tend to overthink the licensing. Remember that one concurrent user means that one person can be performing a task at a given time. That does not mean that only one user can be on the system at a time, it means that only one person can be refreshing a report or designing a dashboard. There are tons of ways you can access your data or reports without consuming a license. I've seen cases where five concurrent licenses support thousands of users."
"It is not cost-effective. It is expensive."
"SAP is losing market to its competitors because of its costly user license and licensing model. They can do much better on the licensing side. That's what Microsoft has been doing, and that's why Power BI is gaining market share at the moment. SAP needs to relax a little bit on the licensing part. If Microsoft is giving people a solution that is half of the cost of SAP, people will definitely go with Power BI."
"I have always found SAP BI to be expensive. It is expensive even when you compare SAP BI Cloud with Microsoft Power BI. Power BI is probably around $9.99 per month, and the cheapest SAP BI is around $20, which is double. In terms of price, Power BI is definitely a lot better. If you have budget issues, you may want to go for Power BI."
"There's no additional charge for a Development environment license, so build an additional development server."
"The price and the pricing model are fine. We find the solution does not give us a lot of additional value."
"It has an option of a Cloud Platform (SAP Analytics Cloud) which has a lower price than the on-premise platform, and you can buy individual licences per user.​"
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
847,772 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
12%
Manufacturing Company
7%
Insurance Company
7%
Financial Services Firm
16%
Computer Software Company
11%
Manufacturing Company
9%
Government
8%
 

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: April 2025.
847,772 professionals have used our research since 2012.