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.0
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.1% compared to last year.
Workday Prism Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 1.6% mindshare, up 1.3% since last year.
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Oracle Essbase0.8%
SolarWinds Database Performance Analyzer6.6%
Redgate SQL Toolbelt Essentials6.0%
Other86.6%
Database Development and Management
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Workday Prism Analytics1.6%
Microsoft Power BI14.5%
Tableau Enterprise11.0%
Other72.9%
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.
Anirban Chatterjee - PeerSpot reviewer
Provides superior integration capabilities and ability to handle complex data transformations 
One area for improvement in the solution is the ability to manually update individual rows or columns of data once it has been uploaded. Any correction requires reloading the entire dataset from the source, which can be inefficient. They should include a feature for granular data updates, allowing users to edit specific entries without reloading entire datasets.

Quotes from Members

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

Pros

"It helps us fetch specific data sets per users' requirements."
"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."
"Essbase is extremely stable and low-maintenance."
"The solution can handle a large volume of data."
"The solution is scalable."
"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."
"It is very fast compared to other normal databases, like SQL and MySQL."
"Oracle Essbase is a web integration system that integrates with other data systems."
"The product is easier to use compared to other applications."
"I really like the flexibility the solution provides in terms of data transformation."
"Feature-wise, I feel that the solution's stability is good."
"The customer service and support are pretty good."
"The solution is stable and reliable, with minimal issues affecting its performance."
 

Cons

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

Pricing and Cost Advice

"Essbase is competitively priced."
"I believe the licensing is on a monthly base."
"It is a costly solution."
"The solution is expensive."
"I do not know of the licensing cost, but there are additional costs like 5,00,000 for recruitment modules."
"Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool."
"The solution is very expensive."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
867,370 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%
Insurance Company
8%
Healthcare Company
8%
Computer Software 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.
867,370 professionals have used our research since 2012.