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 (11th)
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.9%, down 1.1% compared to last year.
Workday Prism Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 1.8% mindshare, up 1.3% since last year.
Database Development and Management
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

"Essbase is extremely stable and low-maintenance."
"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'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 a kind of backbone, or back end, for systems like Hyperion Planning."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It is very fast compared to other normal databases, like SQL and MySQL."
"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."
"I have found the most valuable aspect is the user-friendly environment and current features."
"I really like the flexibility the solution provides in terms of data transformation."
"The product is easier to use compared to other applications."
"The solution is stable and reliable, with minimal issues affecting its performance."
"Feature-wise, I feel that the solution's stability is good."
"The customer service and support are pretty good."
 

Cons

"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"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."
"They should improve the solution's performance."
"I would like to see an integration with application performance management and a version control management tool."
"The initial setup could be simplified."
"There is room for improvement in terms of cost-effectiveness."
"The ability to drive external reporting out for development could be improved."
"It is not a very scalable product."
"The visualization techniques must be upgraded."
"There is not much flexibility in how we can add external data within Workday Prisma Analytics."
"When you create certain objects, a lot of the time, the fields are text. They’re not numeric, date, or any other field type"
"One area for improvement in the solution is the ability to manually update individual rows or columns of data once it has been uploaded."
 

Pricing and Cost Advice

"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"It is a costly solution."
"The solution is expensive."
"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."
"Based on whatever I have heard, Workday Prism Analytics is considered an expensive tool."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
865,295 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
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?
Improvements for Oracle Essbase could be made, as there are many tools available now, such as FCCS, TRCS, and ERCS. I find managing the database difficult, especially regarding optimization and dat...
What is your primary use case for Oracle Essbase?
I have been using Oracle Essbase for the last thirteen years and I am into this space for thirty years. I am working on the sales-based platform where I work with different clients for GE, Thomson ...
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 Oracle, Quest Software, Nutanix and others in Database Development and Management. Updated: July 2025.
865,295 professionals have used our research since 2012.