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

MicroStrategy vs Oracle Essbase 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

MicroStrategy
Average Rating
8.2
Reviews Sentiment
6.7
Number of Reviews
160
Ranking in other categories
BI (Business Intelligence) Tools (9th), Embedded BI (4th)
Oracle Essbase
Average Rating
8.4
Reviews Sentiment
5.5
Number of Reviews
14
Ranking in other categories
Database Development and Management (12th)
 

Mindshare comparison

MicroStrategy and Oracle Essbase aren’t in the same category and serve different purposes. MicroStrategy is designed for BI (Business Intelligence) Tools and holds a mindshare of 3.2%, down 3.6% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 1.0% mindshare, up 0.8% since last year.
BI (Business Intelligence) Tools
Database Development and Management
 

Featured Reviews

AJIN S L - PeerSpot reviewer
Experience has shown effective features for analysis, but needs interface improvements
The most effective features of MicroStrategy for data analysis are those that cater to user needs. However, I find Power BI to be more useful when comparing some features, but my company does not choose Power BI due to certain code restrictions. The MicroStrategy interface is not as good as Power BI, especially concerning the user-friendly aspects.
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.

Quotes from Members

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

Pros

"It's user-friendly, also the MTDI cube is a very good approach, as it helps you to use the pre-format instead of using the standard objects from the schema of MicroStrategy."
"The data governance leads people to trust the data that they have, and they know where to get it."
"​Visual Insight gives you the capability of doing self-service analytics. This has been the most powerful and valuable feature.​"
"If you have data, it is not that complex. It's manageable even for end users."
"MicroStrategy's best feature is that it is a user-friendly tool."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"The whole repository side of things is beneficial because you develop it once, and you can use it anywhere, in the Enterprise grade."
"It offers us a lot of out-of-the-box tools, which give us the ability to automate a lot of our administrative tasks. Some things become menial: user creation, restarting a server at 10 o'clock on a Friday - simple things that they really give you the tools to be able to do. That's one thing I really like about the MicroStrategy platform from an administrative perspective."
"Oracle Essbase is a web integration system that integrates with other data systems."
"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 helps us fetch specific data sets per users' requirements."
"Essbase is extremely stable and low-maintenance."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is stable and reliable."
"The solution is scalable."
"The solution can handle a large volume of data."
 

Cons

"It crashes multiple times for even small changes that I make on the fly in the dashboard. After doing all the necessary changes, the MicroStrategy desktop or even the web version kicks the users out, and all the changes are lost. This functionality is buggy in MicroStrategy. It is hard to keep track of all the changes that I have done before. I don't want to make copies of each change that I have made because I would end up creating a hundred dashboards. It is not feasible in a real environment. I haven't worked on integrating MicroStrategy with the cloud. I am not sure how it behaves in the cloud, but I have heard from a few of my friends that there are some hiccups when you kind of sync to the cloud through MicroStrategy."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"Data preparation-wise, it was not so straightforward with respect to getting different sources. Preparing or transforming the data inside and then bringing it onto the dashboard was a bit difficult, and the experience could have been better."
"MicroStrategy's mobile dashboard is still not a RESTful design."
"Needs more visual essence and connectors for the ecosystems, which would be easy to use."
"Preparation, data loading and data management application is challenging with MicroStrategy. It lacks cube-based analytics as it is outdated, meaning there is no memory or fast processing analytics or MMA deployment."
"The areas that have room for improvement in MicroStrategy are mainly related to building additional tools. Specifically, the embedding process has been a bit of a struggle."
"Another feature to consider in the future would be adding some additional offline capabilities without using desktops."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"The initial setup is pretty complex."
"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 would like to see an integration with application performance management and a version control management tool."
"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."
"They should improve the solution's performance."
 

Pricing and Cost Advice

"The pricing list itself is not publicly accessible, so it's a bit opaque."
"​They gave us a good deal.​"
"​The solution is scalable. A little expensive perhaps, but it is scalable.​"
"The price of MicroStrategy is reasonable."
"They offer yearly as well as perpetual licenses."
"There have been actual direct bottomline impacts in terms of extra revenue created from the reporting solutions."
"Now, the price is high."
"For larger businesses, the pricing is logical."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"It is a costly solution."
"The solution is expensive."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
845,485 professionals have used our research since 2012.
 

Comparison Review

it_user6330 - PeerSpot reviewer
May 2, 2013
MicroStrategy vs. Tableau
After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications Tableau has found its sweet-spot as an agile discovery tool that analysts…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
11%
Retailer
8%
Insurance Company
7%
Financial Services Firm
23%
Computer Software Company
12%
Manufacturing Company
8%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about MicroStrategy?
The stability of the product is good.
What is your experience regarding pricing and costs for MicroStrategy?
For larger businesses, I think the pricing is logical, but for smaller companies, it can be a bit costly.
What needs improvement with MicroStrategy?
MicroStrategy could learn from Power BI's user-friendly interface. I find the user interface lacking when compared to Power BI. Additionally, their hyperintelligence could be improved in certain as...
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...
 

Also Known As

No data available
Essbase
 

Overview

 

Sample Customers

Allstate Insurance, Barneys New York, Boston Children's Hospital, Buenos Aires Department of the Treasury, Campbell Soup Company, DHL, eBay, eHarmony, Facebook, Four Seasons Hotels Inc., Godiva, Hard Rock International, LinkedIn, Netflix, Pfizer, SECO (Swiss Government Unemployment Agency), Starbucks, Texas A&M University, Thomson Reuters Markets, US House of Representatives, and the US Postal Service.
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.
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: March 2025.
845,485 professionals have used our research since 2012.