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

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Oracle Essbase enables sophisticated analysis, allowing users to define dimensions and hierarchy beforehand for effective data drilling and slicing.
Essbase is stable, low-maintenance, and reliable, even when handling large volumes of data.
It is highly efficient, scalable, and capable of integrating with other systems like Hyperion Planning.
Essbase offers fast performance compared to other databases, facilitating advanced modeling and data exploration.
It provides flexibility for creating customizable analysis and reporting, including ad hoc report generation.

CONS

The programming language's forecasting functions in Oracle Essbase have limited features.
There is a need for integration with application performance management and version control management tools.
Oracle Essbase is expensive and there is room for improvement in cost-effectiveness.
The initial setup process can be complex and could be simplified.
There is a lack of a financial consolidation module, requiring manual work for financial statement analysis, CAPEX and OPEX analysis, and financial consolidation.
 

Oracle Essbase Pros review quotes

reviewer1760025 - PeerSpot reviewer
Senior Hyperion Consultant at a financial services firm with 10,001+ employees
Jan 12, 2022
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.
reviewer1848270 - PeerSpot reviewer
Director, Financial Systems at a retailer with 10,001+ employees
Apr 27, 2022
Essbase is extremely stable and low-maintenance.
SR
Subject Matter Expert at Cyprobes
Sep 23, 2022
The solution is stable and reliable.
Learn what your peers think about Oracle Essbase. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,082 professionals have used our research since 2012.
SK
Project Manager at Adroit Corporate Services Private Limited
Oct 11, 2022
I have found the most valuable aspect is the user-friendly environment and current features.
reviewer1979718 - PeerSpot reviewer
Software Engineer at a financial services firm with 5,001-10,000 employees
Oct 24, 2022
The solution can handle a large volume of data.
Bikramjeet Singh - PeerSpot reviewer
Senior Reg Reporting Consultant at Bank of America
Mar 27, 2023
It helps us fetch specific data sets per users' requirements.
SE
Software developer at MTNIrancell
Sep 28, 2023
It is highly efficient and easily scalable, particularly for handling large databases.
MA
Executive IT at GBEL
Oct 12, 2023
The solution is scalable.
Prithwish Kumar Ghosh - PeerSpot reviewer
Manager at Capgemini
May 9, 2024
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.
RANOJOY PAUL - PeerSpot reviewer
Analyst at Tata Consultancy
May 9, 2024
It is very fast compared to other normal databases, like SQL and MySQL.
 

Oracle Essbase Cons review quotes

reviewer1760025 - PeerSpot reviewer
Senior Hyperion Consultant at a financial services firm with 10,001+ employees
Jan 12, 2022
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.
reviewer1848270 - PeerSpot reviewer
Director, Financial Systems at a retailer with 10,001+ employees
Apr 27, 2022
The ability to drive external reporting out for development could be improved.
SR
Subject Matter Expert at Cyprobes
Sep 23, 2022
It's an expensive product to use.
Learn what your peers think about Oracle Essbase. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,082 professionals have used our research since 2012.
SK
Project Manager at Adroit Corporate Services Private Limited
Oct 11, 2022
I would like to see an integration with application performance management and a version control management tool.
reviewer1979718 - PeerSpot reviewer
Software Engineer at a financial services firm with 5,001-10,000 employees
Oct 24, 2022
The initial setup could be simplified.
Bikramjeet Singh - PeerSpot reviewer
Senior Reg Reporting Consultant at Bank of America
Mar 27, 2023
They should improve the solution's performance.
SE
Software developer at MTNIrancell
Sep 28, 2023
There is room for improvement in terms of cost-effectiveness.
MA
Executive IT at GBEL
Oct 12, 2023
The initial setup is pretty complex.
Prithwish Kumar Ghosh - PeerSpot reviewer
Manager at Capgemini
May 9, 2024
The consolidation engine, which is HFM or FCCS, needs some room for improvement.
RANOJOY PAUL - PeerSpot reviewer
Analyst at Tata Consultancy
May 9, 2024
The reporting tool of Essbase needs improvement.