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

Oracle Essbase vs Workday Prism Analytics 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 (9th)
Workday Prism Analytics
Average Rating
8.6
Reviews Sentiment
7.6
Number of Reviews
5
Ranking in other categories
BI (Business Intelligence) Tools (17th)
 

Mindshare comparison

Oracle Essbase and Workday Prism Analytics aren’t in the same category and serve different purposes. Oracle Essbase is designed for Database Development and Management and holds a mindshare of 0.8%, down 1.2% compared to last year.
Workday Prism Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 1.6% mindshare, up 1.4% since last year.
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Oracle Essbase0.8%
SolarWinds Database Performance Analyzer6.4%
Redgate SQL Toolbelt Essentials5.9%
Other86.9%
Database Development and Management
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Workday Prism Analytics1.6%
Microsoft Power BI14.1%
Tableau Enterprise10.3%
Other74.0%
BI (Business Intelligence) Tools
 

Featured Reviews

Bhavya N - PeerSpot reviewer
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.
Sarvesh Kumar Jha - PeerSpot reviewer
Provides great flexibility in terms of data transformation
I really like the flexibility the solution provides in terms of data transformation. Workday introduced Prism Analytics mainly because many clients wanted to merge data from different systems and then work with it to get some insights out of it. For that, they previously used tools like Power BI. Workday Prism Analytics gives you the power to do all the data transformations within Workday itself without taking out crucial data to a third system. I really like the way Workday has enabled Prism Analytics to be that one solution where you can bring everything. It also provides you the flexibility that things like the security model of Workday are still in place. You don't have to redo your security configuration if you do the data transformation outside Workday.

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'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."
"It is highly efficient and easily scalable, particularly for handling large databases."
"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."
"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 solution is scalable."
"The customer service and support are pretty good."
"The product is easier to use compared to other applications."
"I really like the flexibility the solution provides in terms of data transformation."
"The solution is stable and reliable, with minimal issues affecting its performance."
"Feature-wise, I feel that the solution's stability is good."
 

Cons

"The initial setup could be simplified."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"It's an expensive product to use."
"The initial setup is pretty complex."
"The ability to drive external reporting out for development could be improved."
"There is room for improvement in terms of cost-effectiveness."
"The reporting tool of Essbase needs improvement."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"One area for improvement in the solution is the ability to manually update individual rows or columns of data once it has been uploaded."
"When you create certain objects, a lot of the time, the fields are text. They’re not numeric, date, or any other field type"
"There is not much flexibility in how we can add external data within Workday Prisma Analytics."
"It is not a very scalable product."
"The visualization techniques must be upgraded."
 

Pricing and Cost Advice

"It is a costly solution."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"The solution is expensive."
"Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool."
"The solution is very expensive."
"I do not know of the licensing cost, but there are additional costs like 5,00,000 for recruitment modules."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
868,787 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
9%
Insurance Company
8%
Retailer
6%
Financial Services Firm
12%
Government
8%
Insurance Company
8%
Healthcare Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise1
Large Enterprise14
No data available
 

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 ...
What is your experience regarding pricing and costs for Workday Prism Analytics?
Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool. In fact, that has been one of the hindrance factors for Workday in making Prism Analytics more sellable.
What needs improvement with Workday Prism Analytics?
I think there are still some gaps in the solution. There is not much flexibility in how we can add external data within Workday Prisma Analytics. For now, Workday has enabled the SFTP server and Am...
What is your primary use case for Workday Prism Analytics?
As a consultant, I use Prism Analytics to implement my client systems. I first have design sessions with them, where we discuss their business gaps and then understand how Workday Prism Analytics c...
 

Also Known As

Essbase
Prism Analytics
 

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.
Denny's
Find out what your peers are saying about Nutanix, Oracle, Quest Software and others in Database Development and Management. Updated: September 2025.
868,787 professionals have used our research since 2012.