Oracle Essbase Reviews & Product Details

Oracle Essbase Overview

What is 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 Details
Product Description

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.


Seller Details
Seller
Oracle
Ownership
NYSE:ORCL
Company Website
Phone
+1 (650) 506-7000
Year Founded
1977
HQ Location
Redwood Shores, CA
Total Revenue (USD mm)
$39,506
Twitter
@Oracle
778,474 Twitter followers
LinkedIn® Page
www.linkedin.com
186,456 employees on LinkedIn®
Description

Oracle Corporation develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems.

Show More

Oracle Essbase Screenshots

Answer a few questions to help the Oracle Essbase community
Have you used Oracle Essbase before?
Yes

Oracle Essbase Reviews

Write a Review
Filter reviews

LinkedIn®
Connections
Popular Mentions
Showing 230 Oracle Essbase reviews
Popular Mentions
Showing 230 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Review Type
Region
Already have Oracle Essbase?
Write a Review
Manager/Controller, Shop Your Way (loyalty program), Marketing, Licensed Businesses
Accounting
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Organic
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

Sometimes it crashes! That is sometimes I lose connection with the server and it makes everything in Excel freeze up. This is very frustrating. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It can take a team to implement. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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. Review collected by and hosted on G2.com.

Show More
Show Less
UA
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

Sometimes it won't pull data when you have fields wrong. Every time you have to login again, which is a little bit annoying. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Make it more user friendly: 1. it could be easier to set up a new Essbase report; 2. it could be easier to refresh Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Getting historic or current financials without running reports from Oracle. Have all the data you needed easily on the excel. Review collected by and hosted on G2.com.

Show More
Show Less
AO
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

You can quickly slice and dice data at a high level, forcing you to focus on the big picture Review collected by and hosted on G2.com.

What do you dislike?

hard to drill back into transactional details Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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

Show More
Show Less
AI
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

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 Review collected by and hosted on G2.com.

What do you dislike?

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. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

N/A Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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 Review collected by and hosted on G2.com.

Show More
Show Less
UC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Customization is very easy and reports can be extracted in simple steps. Review collected by and hosted on G2.com.

What do you dislike?

The product is overall to be worth buying. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

"Effective and much needed accounting as well as financial tool.Chances of errors are very less as lot maker checker checks can be made." Review collected by and hosted on G2.com.

Show More
Show Less
Hyperion Architect
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

EPM suit is a vital part of our financial model. Data is easily monitored and transactions between cubes is fabulous. Review collected by and hosted on G2.com.

Show More
Show Less
IT Business Analyst
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

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). Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Consolidations of financial data, USD translation, intercompany eliminations, consolidationss, product line allocations, customized management and financial reports Review collected by and hosted on G2.com.

Show More
Show Less
Solutions Architect
Retail
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

The growth in the product over the years to address business changing needs Review collected by and hosted on G2.com.

What do you dislike?

Lack of relevant Integration API's without use of report scripts or MDX Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Understand how the product fits into an Oracle SOA to better understand the services and API options Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Financial analytics and what if analysis Review collected by and hosted on G2.com.

Show More
Show Less
BA
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

this was the required DB for hperion and it satisfied the requirements for the hyperion product we are currently using Review collected by and hosted on G2.com.

What do you dislike?

I find it very difficult to navigate in essbase it is a relational database and i am not as familiar with it Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

none Review collected by and hosted on G2.com.

Show More
Show Less
AH
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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 Review collected by and hosted on G2.com.

What do you dislike?

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 ? Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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. Review collected by and hosted on G2.com.

Show More
Show Less
Business Systems Analyst
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

Dimension training can be difficult for new users to get to know a cube. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Cash Forecasting with the ability for users to re-categorize cash transactions. Financial Reporting withg multiplate layers to the underlying data. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Managing Director
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Financial planning, sales analysis, workforce planning, capital planning, product profitability, etc. Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Essbase allows users to quickly retrieve both large datasets and specific cuts of data. Review collected by and hosted on G2.com.

Show More
Show Less
Director Financial Systems & Reporting
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Ease of use, ability to solve the toughest analytical challenges Review collected by and hosted on G2.com.

What do you dislike?

Oracle isnt doing enough to support and expand the On Premise feature and functionality capabilities. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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! Review collected by and hosted on G2.com.

Show More
Show Less
AH
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

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! Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Able to assign hundreds or even thousands of members with little or no degradtion in performance. Review collected by and hosted on G2.com.

Show More
Show Less
CI
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

I really like this product in the Oracle toolset. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Normalizing actuals in operational data, and being able to complete driver-based forecasting and planning in a fully customizable environment. Review collected by and hosted on G2.com.

Show More
Show Less
Manager Hyperion Planing
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Having ways to compile and dashboard data for FPA users Review collected by and hosted on G2.com.

What do you dislike?

Still working to understand the full usage of the tool and how to integrate with our on prem data Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Have not rolled out to end users yet, but hoping to better provide analysts with the ability to analyse data versus compilining data Review collected by and hosted on G2.com.

Show More
Show Less
Solution Architect
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Full access to all optimization and tuning options. Visibility to performance-related metrics to maximize efficient use of hardware. Review collected by and hosted on G2.com.

What do you dislike?

A little difficult to train novice users on Review collected by and hosted on G2.com.

Recommendations to others considering the product:

FInd an expert to help you implement, and enjoy the benefits of a great technoclogy Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Super data collection and analytics. Eliminating independent Excel and Access solutions. Review collected by and hosted on G2.com.

Show More
Show Less
CA
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Given the ability to migrate the Essbase applications to cloud, with hybrid capabilities gives the best Database with much anticiapted analytics reporting capbilities Review collected by and hosted on G2.com.

What do you dislike?

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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 Review collected by and hosted on G2.com.

Show More
Show Less
CC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

calculation engine, aggreagation power, outline order, properties, how fast is to calculate and how nice is to create outlines and how he respect the order of members and its properties. Review collected by and hosted on G2.com.

What do you dislike?

how slow is to extract data from it. ITs always hard to export and integrate it in your Data warehouse because the difficult way to extrat from it. metadata is also a little bit hard to maintain Review collected by and hosted on G2.com.

Recommendations to others considering the product:

easier way to integrate essbase Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

all kind of problems from forecast to bi applications Review collected by and hosted on G2.com.

Show More
Show Less
UG
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

There is potential to report on multiple subject areas and it is intuitive. Review collected by and hosted on G2.com.

What do you dislike?

It is very distinct and difficult to use when different teams have different needs. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Making it more useful to everyone not just for specific team uses. Review collected by and hosted on G2.com.

Show More
Show Less
Staff Vice President - Business Intelligence
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

The ability to select metadata that is relevant to me. I also like multiple connections on the same Smart View sheet Review collected by and hosted on G2.com.

What do you dislike?

For some users, it is difficult to navigate through the metadata to get to relevant intersections Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

KPI support and data warehouse Review collected by and hosted on G2.com.

Show More
Show Less
BI Technical Analyst
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Essbase does help our finance team manage their financials and forecasts. Review collected by and hosted on G2.com.

What do you dislike?

Our Essbase needs to be optimibezed, so really the only thing missing is our own training on the tool. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are solving our problems of financial forecasting and analysis using Essbase. Review collected by and hosted on G2.com.

Show More
Show Less
AE
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

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. Review collected by and hosted on G2.com.

What do you dislike?

Many of the load rule interface are redundent with our upstream processing, such as search and replace or column addition/substraction. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Automation is much easier and also outline management is more user-friendly than before. Review collected by and hosted on G2.com.

Show More
Show Less