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

"Oracle Essbase is a web integration system that integrates with other data systems."
"It helps us fetch specific data sets per users' requirements."
"The solution is scalable."
"It is very fast compared to other normal databases, like SQL and MySQL."
"Essbase is extremely stable and low-maintenance."
"I have found the most valuable aspect is the user-friendly environment and current features."
"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 kind of backbone, or back end, for systems like Hyperion Planning."
"The reporting features the solution offers are excellent."
"First of all, visualization tools, productivity, and predictive forecasting are mature."
"The ability to merge dimensions in a report is great."
"One of the most valuable features of SAP BusinessObjects is that it's not a dashboarding solution. It's a real product. You can create operational reports and publish it to anyone. You can create schedules. You can create a Universe, semantic layers. There's also a security configuration. It's a huge product, so if there is a business need, SAP BusinessObjects can cover it."
"Has features that can be leveraged to scale out and scale up."
"The planning and dashboarding features have been useful. Additionally, the fixed-format reports are good."
"The reports are most valuable. If it is a single-source universe, based on only one database, the performance, and the reporting tool is user-friendly, and users are very familiar with the tool and are comfortable using it."
"It allows the analysis of business data and enables decisions based on the analysis."
 

Cons

"The initial setup is pretty complex."
"It's an expensive product to use."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"There is room for improvement in terms of cost-effectiveness."
"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 reporting tool of Essbase needs improvement."
"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."
"The solution could be less expensive. It's a bit pricey now."
"The solution is not good for self-services, they can improve in this area."
"The UI could be updated a bit."
"The integration could be improved. The SAP suite has some integration problems and it has some huge development needs. For example, when you use Power BI, if you publish a dataset to the web, there is no issue in seeing the data with the report. The data and report are integrated automatically. Or when you use QlikView, when you publish the QVD file, the report is integrated with QVD. Also, with Tableau, when you publish the data, it's in the hyper database, in the memory, and the dashboard with data is integrated seamlessly. In the SAP side, it's not easy. There are lots of business layers. There are also some performance issues in the SAP BusinessObjects suite. They should focus on the technologies. We are partners and every step of the way, SAP asks us for money. If you want to see the products, the PDFs, if you want to learn the product, online training, etc., everything has a cost on the SAP site. Because of this, partners try to get to know the products on their own. SAP only focuses on the sales side—only money is important for SAP, not the quality. In that way, the operation is not easy on the SAP side. As a suggestion, they should focus on customers first instead of money."
"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."
"Currently, we can use Explore to do data discovering, but cannot generate charts."
"The solution can improve by having more analytical features."
"Technical support may not always be timely or effective."
 

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."
"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."
"Just work with SAP to make sure you have enough licenses but don't go overboard."
"Its price is fair."
"The SAP BusinessObjects Business Intelligence Platform has to improve its licensing cost."
"SAP BusinessObjects Business Intelligence Platform is an expensive application."
"​It is not an expensive platform. The licensing is for a package of users starting at 10 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."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
845,406 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
8%
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: March 2025.
845,406 professionals have used our research since 2012.