# Oracle Essbase Reviews
**Vendor:** Oracle  
**Category:** [Financial Analysis Software](https://www.g2.com/categories/financial-analysis)  
**Average Rating:** 4.3/5.0  
**Total Reviews:** 245
## About Oracle Essbase
Oracle Essbase is the industry-leading multi-dimensional online analytical processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications.



## Oracle Essbase Pros & Cons
**What users like:**

- Users value the **Excel integration** through SmartView for efficient multidimensional analysis in Oracle Essbase. (1 reviews)
- Users value the **multidimensional analysis and Excel integration** with SmartView, enhancing their data insights effectively. (1 reviews)

**What users dislike:**

- Users find the **interface outdated** and report it is overly sensitive to errors when retrieving data. (1 reviews)
- Users find the **interface not user-friendly** and often face errors in data retrieval, complicating their experience. (1 reviews)

## Oracle Essbase Reviews
  ### 1. Powerful Multidimensional Analysis with Smooth Excel SmartView Integration

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.)

**Reviewed Date:** February 25, 2026

**What do you like best about Oracle Essbase?**

Ability to do multidimensional analysis, excel integration through smartview

**What do you dislike about Oracle Essbase?**

Interface feels dated, very sensitive to errors in retrieving data

**What problems is Oracle Essbase solving and how is that benefiting you?**

Allows us to get ride of disconnected excel files and manual consolidation. Automated consolidations and roll up with essbase are making processes easier.

  ### 2. My personal experience about essbase

**Rating:** 4.5/5.0 stars

**Reviewed by:** Rohith P. | Financial Reviewer, Enterprise (> 1000 emp.)

**Reviewed Date:** April 29, 2023

**What do you like best about Oracle Essbase?**

Data is loaded in Essbase in realtime. No time lag is needed to retrieve it. I also like its integration with other apps such as spreadsheet. The performance is fast. As per my knowledge, this gives the best dashboard experience.

**What do you dislike about Oracle Essbase?**

Initial setup was very tough. Patches are time consuming. New employees who join the time are finding difficult to develop learning curve to use this product easily.

**What problems is Oracle Essbase solving and how is that benefiting you?**

I work in a multi national manufacturing company(OEM). We use Essbase to analyze data to identify trends, make predictions and identify places where financial performance and warehouse efficiency can be included. Financial data is being analysed at multiple levels such as location, product code, time period.

  ### 3. One of the best for heavy reporting

**Rating:** 4.0/5.0 stars

**Reviewed by:** Abhijat G. | Senior Data Engineer, Mid-Market (51-1000 emp.)

**Reviewed Date:** June 08, 2023

**What do you like best about Oracle Essbase?**

Ability to have capability of processing and reporting at same platform

**What do you dislike about Oracle Essbase?**

The UI. Could be more intuitive. It looks skmilar to sql dbms

**What problems is Oracle Essbase solving and how is that benefiting you?**

Enabling our team to solve reporting issues on a platform.

  ### 4. Powerful Business Logic Calculations using Essbase

**Rating:** 2.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.)

**Reviewed Date:** July 28, 2022

**What do you like best about Oracle Essbase?**

Generally, it is used for financial purposes, but it is flexible to be used for other analytic purposes, like mathematical models, statistical models, and so on.

**What do you dislike about Oracle Essbase?**

The downside of essbase is the performance of calculation scripts. The script could take minutes if not hours to run and the debugging requires a skillset to understand

**What problems is Oracle Essbase solving and how is that benefiting you?**

It allowed faster forecast cycle and consolidations during month end. Comparatively, it also helped us improve our reporting using smartview.

  ### 5. Very Intuitive Oracle Essbase

**Rating:** 5.0/5.0 stars

**Reviewed by:** Eulomar A. | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 08, 2023

**What do you like best about Oracle Essbase?**

One of the most intuitive platform I've used

**What do you dislike about Oracle Essbase?**

I cannot think of something while using it

**What problems is Oracle Essbase solving and how is that benefiting you?**

Consolidation and financial planning purposes

  ### 6. Oracle Essbase Review

**Rating:** 4.5/5.0 stars

**Reviewed by:** George H. | Manager/Controller, Shop Your Way (loyalty program), Marketing, Licensed Businesses, Accounting, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 02, 2020

  ### 7. Oracle Essbase - Perfect Business Solution

**Rating:** 5.0/5.0 stars

**Reviewed by:** Paarth K. | Student, Mid-Market (51-1000 emp.)

**Reviewed Date:** March 02, 2022

**What do you like best about Oracle Essbase?**

Oracle Essbase is one of the most powerful business analytics solutions. One thing, I liked most about using Oracle Essbase is its flexibility & Rapid Deployment. Every day Oracle Essbase is providing new features and functionalities to the product. We could also use on-the-fly analytic models in our industry. In the Rapid deployment, Oracle Essbase doesn't take much time in installing, configuration and all, we can do it very easily in less time.

**What do you dislike about Oracle Essbase?**

I don't dislike it. But I want a few things to be improved. The Overall UI of the application is a bit consolidated. I think it should be enhanced. And, another thing is that Oracle Essbase is not beginner-friendly to understand and execute. But if you're into the Essbase, then you should try to discover it, it would be very much profitable.

**Recommendations to others considering Oracle Essbase:**

I'll highly recommend everyone, who are into the Essbase. Oracle Essbase, comes with some of the amazing power-packed features, which you must use. You can create your private VCN and connect with some on-premises data sources. Apart from this, you could also go for, creating your own team while building the product.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Some of the benefits, which I definitely like to mention are - You can easily design, manage and scale in the cloud. Sometimes, it becomes problematic for us, to deploy our applications. But, with the help of Oracle Essbase, you can easily deploy your application from multiple data sources. It is Open-Source, Scalable and very flexible.

  ### 8. Great Database Development Tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** Mansimran Singh K. | Analyst, Enterprise (> 1000 emp.)

**Reviewed Date:** April 15, 2022

**What do you like best about Oracle Essbase?**

It is one of the best OLAP (Online Analytical Processing) servers which helps in providing an environment for using Pre-Packaged applications and creating custom analytic and enterprise performance management applications.

**What do you dislike about Oracle Essbase?**

One of the disadvantages of this software is that it is not very fast when it comes to extracting the data and in my opinion, it needs a better API. Also, there is a great need for proper documentation as there are a lot of undocumented commands.

**What problems is Oracle Essbase solving and how is that benefiting you?**

This software provides faster and more detailed forecast cycles. It helps the businesses to improve their processes as you can do a lot of multiples things more quickly as the business can create complicated models which can take a lot of time to solve without any software.

  ### 9. Old but once upon a time it was a gold!!

**Rating:** 3.5/5.0 stars

**Reviewed by:** Sukumar M. | SAP Consultant, Small-Business (50 or fewer emp.)

**Reviewed Date:** March 09, 2022

**What do you like best about Oracle Essbase?**

The best thing about Essbase is that it supports a multidimensional database, which is one of the most used database types in large organizations. The UI may not be the best in the category but it has its advantage.

**What do you dislike about Oracle Essbase?**

Most people say that Essbase lacks a great UI, that's true. New users might find themselves nowhere without any training about its uses. If carefully not handled then a simple mistake can be a nightmare for your organization.

**What problems is Oracle Essbase solving and how is that benefiting you?**

We use to take a different kind of input from users in a preformatted excel sheet which consist of a lot of fields. When users entered data, Essbase store those data on our server.

  ### 10. Yes to EssBase

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.)

**Reviewed Date:** March 01, 2022

**What do you like best about Oracle Essbase?**

Ease of use in almost all features
Ease of connectivity
Ease of creating a Database
Provides great security and data normalization
Data management is very effective and hassle free.

**What do you dislike about Oracle Essbase?**

Some features are not so easy to use
Tight coupling of some features causes the tool to be used with caution.
Data retrieval is very high speed
Some of the errors shown while using the tool are quite difficult to understand.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Databases of multiple instances of various tools
As there is ease to create multiple DB instances, there is also a benefit of classification of data from different sources.

  ### 11. A must have for FP&A

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Human Resources | Enterprise (> 1000 emp.)

**Reviewed Date:** November 09, 2021

**What do you like best about Oracle Essbase?**

This tool is highly scalable. It can be customized to quickly dissect small to large amounts of financial or statistical data. The capability to save premade templates and automate them is fantastic.

**What do you dislike about Oracle Essbase?**

Macros and other excel formulas often conflict with pre-saved templates. We're also seeing excel version compatibility issues at times. The overall UI is a bit dated and very technical when something doesn't work well. It would be better if we could quickly receive error messages that display possible fixes.

**Recommendations to others considering Oracle Essbase:**

Enjoy the product

**What problems is Oracle Essbase solving and how is that benefiting you?**

FP&A for a large corporate finance team. P&L analysis and other reviews with executive management. Ability to run reports and distribute them to decision makers

  ### 12. Great calculation engine for our daily financial analysis and planning

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Food & Beverages | Mid-Market (51-1000 emp.)

**Reviewed Date:** August 19, 2021

**What do you like best about Oracle Essbase?**

The super fast aggregation and drill down , best calculation engine. 
Ability to connect to multiple different databases on single sheet to perform analysis and drill down.

Hierarchical views.
Alternate hierarchies 
Security access that can be very granualr for financial controls.
Audit reports

**What do you dislike about Oracle Essbase?**

The on prem is costly, but nothing compared to the cloud cost.  
They need a better front end for Essbase for users to have new "jazzy" feel

**What problems is Oracle Essbase solving and how is that benefiting you?**

we are running our whole financial planning and analysis processes in Essbase.
we have about 20 cubes that does all kinds of variance analysis, P&L calculations, Balance Sheet reporting, Cash analysis etc.
We're using smartview to access multiple data sources and create book reports.

we have been able to pinpoint any data/$$ issues down to penny through analysis in Essbase.  It has saved company lot of money overtime, when we're able to turn around our reporting and any audit queries in minutes.

  ### 13. Easy to understand

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Medical Devices | Mid-Market (51-1000 emp.)

**Reviewed Date:** January 06, 2022

**What do you like best about Oracle Essbase?**

Can track each and everthing and its more detailed

**What do you dislike about Oracle Essbase?**

It will be better if we can customised more easily

**What problems is Oracle Essbase solving and how is that benefiting you?**

It is use mainly to track inventory and our end users

  ### 14. Powerful data visibility and insights

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.)

**Reviewed Date:** November 09, 2021

**What do you like best about Oracle Essbase?**

It is flexible and be used not only for financial analysis but also other business statistical modeling.

**What do you dislike about Oracle Essbase?**

Extracting data seems a bit slower than what I would expect from this tool.

**Recommendations to others considering Oracle Essbase:**

Make sure you choose a first class implementation team to set up Oracle Essbase.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Customer adoption and product feature analysis and cost allocation.

  ### 15. Good service

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Management Consulting | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 20, 2021

**What do you like best about Oracle Essbase?**

The multidimensional aspect of this database platform makes it easy to integrate several features into one.

**What do you dislike about Oracle Essbase?**

It's a bit complex to learn but once you learn it it's very productive.

**What problems is Oracle Essbase solving and how is that benefiting you?**

It is flexible with a variety of data analytics.

  ### 16. Frequent user of Business Objects

**Rating:** 5.0/5.0 stars

**Reviewed by:** George H. | Enterprise (> 1000 emp.)

**Reviewed Date:** September 23, 2020

**What do you like best about Oracle Essbase?**

Allows you to pull company financial data into Excel.  It allows you to do account reconciliation, division level financial statements, all kinds of queries.  It also allows various cubes within the company.  You can have data sets for different operations, such as marketing and financial reporting.  It is very flexible, I frequently break stuff up by division and unit.

**What do you dislike about Oracle Essbase?**

Sometimes it crashes!  That is sometimes I lose connection with the server and it makes everything in Excel freeze up.  This is very frustrating.

**Recommendations to others considering Oracle Essbase:**

It can take a team to implement.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Account reconciliatons, unit and division level financial statements, month/ytd comparisons, loading plan and forecasts for all businesses.  Also building accounts and views which can be automatically downloaded into 10-K, 10-Q and other SEC filings.  it is used by a huge number of people at our company.  It is hard to imagine doing business wihtout it.

  ### 17. Very Intuitive

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.)

**Reviewed Date:** August 24, 2021

**What do you like best about Oracle Essbase?**

It's straightforward to use and very intuitive

**What do you dislike about Oracle Essbase?**

It can be slow at times, depending on the internet connection.

**What problems is Oracle Essbase solving and how is that benefiting you?**

The business problem I have solved with Essbase is finding account details at specific points during the year. The benefit I have realized is being able to pinpoint account detail at any moment to see the changes

  ### 18. Pulling Financial Data  From Accounting Software to Excel In Five Seconds

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Accounting | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 19, 2020

**What do you like best about Oracle Essbase?**

Easily pull and present the financial/accounting data from the Oracle accounting system to the excel file by defining what you like to see and refresh the Essbase. No need to go into the Oracle and run different reports.

**What do you dislike about Oracle Essbase?**

Sometimes it won't pull data when you have fields wrong. Every time you have to login again, which is a little bit annoying.

**Recommendations to others considering Oracle Essbase:**

Make it more user friendly: 1. it could be easier to set up a new Essbase report; 2. it could be easier to refresh

**What problems is Oracle Essbase solving and how is that benefiting you?**

Getting historic or current financials without running reports from Oracle. Have all the data you needed easily on the excel.

  ### 19. Essbase helps for insights into the business

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Oil & Energy | Mid-Market (51-1000 emp.)

**Reviewed Date:** September 15, 2020

**What do you like best about Oracle Essbase?**

You can quickly slice and dice data at a high level, forcing you to focus on the big picture

**What do you dislike about Oracle Essbase?**

hard to drill back into transactional details

**What problems is Oracle Essbase solving and how is that benefiting you?**

Financial planning and forecasting.  We can push that down to all end users instead of having a simple excel model on one persons computer

  ### 20. Essbase is Easy!

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 29, 2020

**What do you like best about Oracle Essbase?**

I love how easy it is to use.  The depth and flexibility is fantastic.  The integration with Excel is also great and makes things easy and more integrated

**What do you dislike about Oracle Essbase?**

A lot of the different languages make it hard to be profiecient in knowing all of the functions .  Calc scripts, MDX and business rules are a lot to have to know and keep on top of.

**Recommendations to others considering Oracle Essbase:**

N/A

**What problems is Oracle Essbase solving and how is that benefiting you?**

We are trying to find ways for multiple business units to find value in using this.  Once we find different ways to manipulate and use in multiple areas, we will be better off

  ### 21. Valuable accounting/financial tool that caters and fixes all accounting issues

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer & Network Security | Enterprise (> 1000 emp.)

**Reviewed Date:** July 29, 2020

**What do you like best about Oracle Essbase?**

Customization is very easy and reports can be extracted in simple steps.

**What do you dislike about Oracle Essbase?**

The product is overall to be worth buying.

**Recommendations to others considering Oracle Essbase:**

Operations in different country and consolidating the accounts is a big issue for every globally run company. With this tool consolidation process can run as per the instructions and time period fedded.

**What problems is Oracle Essbase solving and how is that benefiting you?**

"Effective and much needed accounting as well as financial tool.Chances of errors are very less as lot maker checker checks can be made."

  ### 22. Robust analytic tool with lots of new features

**Rating:** 4.5/5.0 stars

**Reviewed by:** Piyush S. | Hyperion Architect, Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

We use Essbase, Planning, FDMEE and HFM in our company, and we really like the data analysis ease for reporting purposes. For planning and budgeting needs Hyperion has been our buddy for last 8 years now, and we absolutly love it. We recently got into FDMEE/ODI integration too whch really widened up the horizons for enhancements. Really like all applications UTILITIES and the ease to administer data and meradata. Setting up security is robust and very simple with advance features as well.

**What do you dislike about Oracle Essbase?**

Eventual crashes of Hyperion Services like Essbase and Planning.
Performances issues for Planning and Hyperion Finanacial Management tool for on-prem.
New reporting RAA missing from 11.1.2.4.900 version causing installation and configuration problems.

**What problems is Oracle Essbase solving and how is that benefiting you?**

EPM suit is a vital part of our financial model. Data is easily monitored and transactions between cubes is fabulous.

  ### 23. Essbase & SV

**Rating:** 3.5/5.0 stars

**Reviewed by:** Yuri F. | IT Business Analyst, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

I like the flexibility Essbase offers to users to design queries and reports. As an admin, I like the multitude of commands and functionality available to perform data loads and calculations.

**What do you dislike about Oracle Essbase?**

We are experiencing issues with stability of Essbase service. This may be related that we are currently using an old version of SmartView (about 2 years old). Older SmartView works well for multi-grid submits, whereas one of the versions we tested did not support this functionality correctly (we had reported this to Oracle).

**What problems is Oracle Essbase solving and how is that benefiting you?**

Consolidations of financial data, USD translation, intercompany eliminations, consolidationss, product line allocations, customized management and financial reports

  ### 24. Essbase over last 10 years

**Rating:** 5.0/5.0 stars

**Reviewed by:** Johnnie J. | Solutions Architect, Retail, Enterprise (> 1000 emp.)

**Reviewed Date:** September 17, 2019

**What do you like best about Oracle Essbase?**

The growth in the product over the years to address business changing needs

**What do you dislike about Oracle Essbase?**

Lack of relevant Integration API's without use of report scripts or MDX

**Recommendations to others considering Oracle Essbase:**

Understand how the product fits into an Oracle SOA to better understand the services and API options

**What problems is Oracle Essbase solving and how is that benefiting you?**

Financial analytics and what if analysis

  ### 25. used for hyperion

**Rating:** 3.5/5.0 stars

**Reviewed by:** crystal h. | BA, Small-Business (50 or fewer emp.)

**Reviewed Date:** September 17, 2019

**What do you like best about Oracle Essbase?**

this was the required DB for hperion and it satisfied the requirements for the hyperion product we are currently using 

**What do you dislike about Oracle Essbase?**

I find it very difficult to navigate in essbase it is a relational database and i am not as familiar with it

**What problems is Oracle Essbase solving and how is that benefiting you?**

none 

  ### 26. Essbase On-Premise 

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

We really love Essbase and Planning ,The way it works is really easy .We have PBCS now and even that works as expected for ONLY planning apps.But for ESSABSE stand alone we really need some cloud cleart cut option

**What do you dislike about Oracle Essbase?**

Cloud Version of Essbase ,.....we dont know what it is....or its not clear.
Smartview performance is not good we need to buy Dodecca for our large ASO drill for faster drills and why cant we acieve this in smarview ?

**What problems is Oracle Essbase solving and how is that benefiting you?**

On-premise : We can create as many application as we want and test what ever we want
Cloud: we are missing that flexibility and we feel like we dont have owenership of our system.

  ### 27. Powerful excel based tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** Jonathan N. | Business Systems Analyst, Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

Essbase is a simple tool that provides users with a dynamic way to access data in a format similar to them (pivot table like). The ability to write back data and interact with data on a live basis is great.

**What do you dislike about Oracle Essbase?**

Dimension training can be difficult for new users to get to know a cube.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Cash Forecasting with the ability for users to re-categorize cash transactions. Financial Reporting withg multiplate layers to the underlying data.

  ### 28. Essbase is great

**Rating:** 5.0/5.0 stars

**Reviewed by:** Matthew G. | Senior Managing Director, Small-Business (50 or fewer emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

Rapid aggregation of data in both BSO and ASO, ease of use via smartview for self-service reporting for business users, depth & flexibility of function library for writing calculations, financial intelligence.

**What do you dislike about Oracle Essbase?**

Many languages to learn to achieve proficiency: Essbase calc scripting, MaxL, MDX, DOS scripting, and for advanced users, PowerShell/Java/etc.  Many administration tasks seem like they could be simplified or automated.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Financial planning, sales analysis, workforce planning, capital planning, product profitability, etc.

  ### 29. Essbase continues to improve. 

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

What is best about essbase is it’s seemless integration with Excel. Most users are financial professionals who are already familiar with building reports in excel and want a fast data retrieval. Essbase offers users the speed and ease of use they expect. 

**What do you dislike about Oracle Essbase?**

What I dislike is how hard it is to hook essbase into Power BI. My company has adopted power bi and I’ve found it difficult to hook my essbase cube into it. A work around is to build a bunch of back end retrievals and individually link them to my power bi report. 

**What problems is Oracle Essbase solving and how is that benefiting you?**

Essbase allows users to quickly retrieve both large datasets and specific cuts of data. 

  ### 30. Essbase

**Rating:** 4.0/5.0 stars

**Reviewed by:** Sal R. | Director Financial Systems & Reporting, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Ease of use, ability to solve the toughest analytical challenges

**What do you dislike about Oracle Essbase?**

Oracle isnt doing enough to support and expand the On Premise feature and functionality capabilities. 

**What problems is Oracle Essbase solving and how is that benefiting you?**

Very open ended, I have been working with Essbase for 20 years and I havent found many analytical challenges that I couldnt use essbase to solve. It has always been a solution in search of a problem, and fortunately I always find problems to solve!

  ### 31. From relaltional to multi-dimensional

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Ever since I've been introduced to Essbase - multi-dimensional database (which was around 12 years ago now), Ive never looked back to the more traditional relational databases. Greatest upside for me is the definition of multiple dimensions paving the way for different pivots and point of view analysis.

**What do you dislike about Oracle Essbase?**

The only thing I slightly dislike is the multiple scripting languages you have to learn like Calc scripts, MDX, business rules, and now groovy. WHy don't Oracle just integrate all these into one languge? Just pick one and stick with it!

**What problems is Oracle Essbase solving and how is that benefiting you?**

Able to assign hundreds or even thousands of members with little or no degradtion in performance.

  ### 32. On Premise Essbase - Spreadsheet Database Forevor

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Essbase and Planning are my favorite tools for Forecasting, Planning, and Analytics using a multi-dimensional framework. Ad hoc analysis in Smart View paired with Essbase continues to be incredibly valuable tool for getting through the close process and forecasting/budgeting cycles. The flexibility and customizability of cubes and data loads and calc scripts and security continue to allow for better faster decision making in the finance world.

**What do you dislike about Oracle Essbase?**

I really like this product in the Oracle toolset.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Normalizing actuals in operational data, and being able to complete driver-based forecasting and planning in a fully customizable environment.

  ### 33. Still Learningq

**Rating:** 2.5/5.0 stars

**Reviewed by:** Amy M. | Manager Hyperion Planing, Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

Having ways to compile and dashboard data for FPA users

**What do you dislike about Oracle Essbase?**

Still working to understand the full usage of the tool and how to integrate with our on prem data

**What problems is Oracle Essbase solving and how is that benefiting you?**

Have not rolled out to end users yet, but hoping to better provide analysts with the ability to analyse data versus compilining data

  ### 34. Essbase Guru

**Rating:** 4.0/5.0 stars

**Reviewed by:** Dan K. | Solution Architect, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Full access to all optimization and tuning options.  Visibility to performance-related metrics to maximize efficient use of hardware.

**What do you dislike about Oracle Essbase?**

A little difficult to train novice users on

**Recommendations to others considering Oracle Essbase:**

FInd an expert to help you implement, and enjoy the benefits of a great technoclogy

**What problems is Oracle Essbase solving and how is that benefiting you?**

Super data collection and analytics.  Eliminating independent Excel and Access solutions.

  ### 35. Essbase on Steriods

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Automotive | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Given the ability to migrate the Essbase applications to cloud, with hybrid capabilities gives the best Database with much anticiapted analytics reporting capbilities

**What do you dislike about Oracle Essbase?**

don't have access to OTL management., cant update the Outline directly from the application, User liesence are based on processor which is costly or based on time used not on named user.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Having ability to migrate the Essbase reporting apps to cloud and then have Data visualization, or analyrics to mash other from of data. ability to create cubes on fly for reporting

  ### 36. Advanced Business Intelligence architect

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer Hardware | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

calculation engine, aggregation power, outline order, properties, how fast it is to calculate and how nice it is to create outlines and how it respects the order of members and their properties.

**What do you dislike about Oracle Essbase?**

The process of extracting data from it is slow. It's always challenging to export and integrate it into your data warehouse due to the difficult extraction process. Additionally, maintaining the metadata is somewhat challenging.

**Recommendations to others considering Oracle Essbase:**

Easier way to integrate Essbase

**What problems is Oracle Essbase solving and how is that benefiting you?**

All kinds of problems from forecast to BI applications

  ### 37. Decent

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Government Administration | Enterprise (> 1000 emp.)

**Reviewed Date:** September 17, 2019

**What do you like best about Oracle Essbase?**

There is potential to report on multiple subject areas and it is intuitive.

**What do you dislike about Oracle Essbase?**

It is very distinct and difficult to use when different teams have different needs.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Making it more useful to everyone not just for specific team uses.

  ### 38. Essbase is a very quick method for consuming data in an accountant-friendly format

**Rating:** 3.5/5.0 stars

**Reviewed by:** Chuck G. | Staff Vice President - Business Intelligence, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

The ability to select metadata that is relevant to me.  I also like multiple connections on the same Smart View sheet

**What do you dislike about Oracle Essbase?**

For some users, it is difficult to navigate through the metadata to get to relevant intersections

**What problems is Oracle Essbase solving and how is that benefiting you?**

KPI support and data warehouse

  ### 39. I have been an Essbase Developer/Administrator for the past year at my current role

**Rating:** 4.0/5.0 stars

**Reviewed by:** Erick M. | BI Technical Analyst, Mid-Market (51-1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Essbase does help our finance team manage their financials and forecasts.

**What do you dislike about Oracle Essbase?**

Our Essbase needs to be optimibezed, so really the only thing missing is our own training on the tool.

**What problems is Oracle Essbase solving and how is that benefiting you?**

We are solving our problems of financial forecasting and analysis using Essbase.

  ### 40. Essbase load rules SQL interface

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in E-Learning | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 28, 2019

**What do you like best about Oracle Essbase?**

I heard the load rules will not have the SQL interface in the future.  I think it is a progress, because all that can be accomplished in the interface can be moved upstream to the SQL staging server with "views" or other features.

**What do you dislike about Oracle Essbase?**

Many of the load rule interface are redundent with our upstream processing, such as search and replace or column addition/substraction.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Automation is much easier and also outline management is more user-friendly than before.

  ### 41. What Essbase means to me

**Rating:** 4.0/5.0 stars

**Reviewed by:** jeff b. | Manager Dodeca Development, Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

It makes me look good when we can build databases that meets the needs ofour usr community

**What do you dislike about Oracle Essbase?**

te whole EPM stack, want it to go back to Essbase likeit looks like 19C will do

**What problems is Oracle Essbase solving and how is that benefiting you?**

budgeting, Actuals and variance analysis

  ### 42. essbase user

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Allows for a multidimensional view of the Finance data. Easily partitionable. The data is easily obtainable through SmartView

**What do you dislike about Oracle Essbase?**

The wait time for the business when building out the cube. Studio was a bit unforgiving when a mistake was made. 

**What problems is Oracle Essbase solving and how is that benefiting you?**

Business uses the tool to pivot on the large set of data and determine insights. They would love to be able to push this into the cloud, but we've run into snags. Hoping to push next year. 

  ### 43. We've had a great experience with Essbase and Planning at Starbucks

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Restaurants | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

The ability to provide users with the tools to complete various aspects of their jobs. Forecast, planning, workforce planning, and others.

**What do you dislike about Oracle Essbase?**

Self-inflicted wounds of design during implementation. Our cube builds aren't optimized according to some consultants who have come in.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Quck reporting and analytics for accounting and finance employees. Increased speed at completed monthly, quartely and annual forecasting ./ planning. Accuracy in those processes due to user abiltiy to quickly pull and assemble data as needed.

  ### 44. Solid Database

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Mining & Metals | Enterprise (> 1000 emp.)

**Reviewed Date:** June 25, 2019

**What do you like best about Oracle Essbase?**

I like the functionality of Essbase.  Once you know how to use it, it's simple, reliable and fast.

**What do you dislike about Oracle Essbase?**

Essbase is difficult for new users.  I find it has a very steep learning curve and requires that users know their dimensions, otherwise if prone to (mostly user) error.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Essbase is so fast and efficient.  As we move into more visualizations for the business, we are employing Essabse for calculations as it is fast and reliable.

  ### 45. overall it was pleasureable

**Rating:** 5.0/5.0 stars

**Reviewed by:** Amit M. | Partner, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

good dashboarding capabilities and much more analytics

**What do you dislike about Oracle Essbase?**

not sure yet.  i need to implement this a bit more before i can comment

**What problems is Oracle Essbase solving and how is that benefiting you?**

i like the analytical aspect and the amount of stuff you can do with it.

  ### 46. Essbase Review

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

The ability to slice and dice our data and provide the business a tool to tell a story is ideal.

**What do you dislike about Oracle Essbase?**

I would like additional reporting capabilities and better retrieval methods.

**What problems is Oracle Essbase solving and how is that benefiting you?**

We have built labor tools, P&L actual and forecasting tools down to store dev capex and coffee forecasting tools.  The biggest benefit is having a platform for our business users to tell their story and align on the same story throughout finance.

  ### 47. I love Essbase

**Rating:** 5.0/5.0 stars

**Reviewed by:** vinay s. | Manager, Financial Systems, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

It allows people to spend time on actual analytics instead of gathering data all the time

**What do you dislike about Oracle Essbase?**

`It is sometimes not as flexbile as I would like it to be

**What problems is Oracle Essbase solving and how is that benefiting you?**

No problems just as yet.

  ### 48. Essbase On Premise

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Essbase being the multi dimensional OLAP product which helps the companies in analyzing in various perspectives. In addition, it supports Drill through mechanism which helps to check the source data my users like  this feature a lot

**What do you dislike about Oracle Essbase?**

the outlike export to excel in on-premise in not availabe despite multiple requests through various forums. also the SR support needs to be improved 

**What problems is Oracle Essbase solving and how is that benefiting you?**

Internal reporting and External reporting. Drill through through essbase studio. 

  ### 49. Best Analytics tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** hitesh g. | Hyperion Essbase & Planning Consultants, Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

Flexablity to dice and slice data. Reporting for month end and SEC reporting

**What do you dislike about Oracle Essbase?**

I've not found anything that i dislike about this tool.

**What problems is Oracle Essbase solving and how is that benefiting you?**

Help my business make informed decisions

  ### 50. No issues with on prem

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.)

**Reviewed Date:** June 24, 2019

**What do you like best about Oracle Essbase?**

No major issues with on prem, however I am technical enough to handle any issues such as services and upgrades/patches to end user connections and training so this could be why I don't mind on pre vs cloud

**What do you dislike about Oracle Essbase?**

There is nothing that I dislike about this product. I have worked with it for years and love it!!

**What problems is Oracle Essbase solving and how is that benefiting you?**

we are looking to move to the cloud


## Oracle Essbase Discussions
  - [What is Oracle Essbase used for?](https://www.g2.com/discussions/what-is-oracle-essbase-used-for)
  - [What is the difference between Hyperion and Essbase?](https://www.g2.com/discussions/what-is-the-difference-between-hyperion-and-essbase)
  - [Is Oracle Essbase a relational database?](https://www.g2.com/discussions/is-oracle-essbase-a-relational-database)
  - [What is Essbase database?](https://www.g2.com/discussions/what-is-essbase-database)
  - [What is Essbase used for?](https://www.g2.com/discussions/what-is-essbase-used-for)

- [View Oracle Essbase pricing details and edition comparison](https://www.g2.com/products/oracle-essbase/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-12+12%3A03%3A31+-0500&secure%5Bsession_id%5D=d6368a0f-afb1-458e-a079-8441fc2d0a55&secure%5Btoken%5D=eb6af75fa9ddeeb5e056ebbaa7b95b5d23b20f7004eb3d33b5a66edaed6a0e0c&format=llm_user)
## Oracle Essbase Integrations
  - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)

## Oracle Essbase Features
**Data Management**
- Data Import
- Data Consolidation
- Data Validation

**Agentic AI - Accounting & Finance**
- Autonomous Task Execution

**Reporting Structure**
- Reporting Hierarchy
- Report Templates
- Report Types

**Standard Analytics**
- Standard KPIs
- Standard Reports
- Financial Statements
- Drill Down

**Custom Analytics**
- Dashboards
- Custom KPIs
- Custom Reports
- Self Service
- Multiple Entities

**Agentic AI - Financial Analysis**
- Cross-system Integration
- Decision Making

## Top Oracle Essbase Alternatives
  - [Vena](https://www.g2.com/products/vena/reviews) - 4.5/5.0 (469 reviews)
  - [Celonis](https://www.g2.com/products/celonis/reviews) - 4.5/5.0 (286 reviews)
  - [Jirav](https://www.g2.com/products/jirav/reviews) - 4.7/5.0 (190 reviews)

