Oracle Hyperion Essbase Developer at HCL Technologies
Real User
Top 20
2024-07-01T09:47:17Z
Jul 1, 2024
If you want to do some analytical processing and you have a huge amount of raw data, Oracle Essbase is a good choice. When you need to analyze the data, transform raw data into consolidated data, do some calculations, and apply Oracle tools to see the hierarchies of the data, Essbase is very effective. For example, if you need to consolidate data from various regions or cities or even on a worldwide or countrywide scale, Essbase is suitable for such analytical operations. There are no other tools that provide as many features for understanding and analyzing data as fast as Essbase. Advice for beginners: As a beginner, there are a few parts you need to understand as basic concepts, like how to build dimensions. If as an end-user, you want to implement this tool in the organization. Then you don't need to worry too much. If you have practical experience with Excel, Smart View is an alternative to access data from Essbase. With Smart View, you can experience the data within Excel and perform some operations without directly using the Essbase application or interacting with the database. Overall rating: I would rate it an eight out of ten for performance and features.
Before using it, I recommend you check with an expert. We have some EPM administrators who can analyze your requirements and tell you which product is suitable for you. Essbase is the database used in the backend, and in the front end, we have several options like Workspace, Planning, and Enterprise Performance Management reporting tools. The experts can comment on which tools are suitable for you. But if you are looking for some performance management tools, then go for Essbase. There are other competitive tools, like SAP, which can also work. Moreover, the interface is very easy. So, it is easy for a beginner to learn to use Oracle Essabase. Within one or one and a half months, any user familiar with company figures can learn it and implement their forms and everything. Overall, I would rate the solution a nine out of ten.
First, I would like to understand what you want to achieve and what amount of data you are handling. You don't use Essbase for small or medium-sized volumes of data. It is especially used for a large volume of data. Otherwise, people use Anaplan or more cheaper products. Also, the nature of the data you are using and the purpose of the data, like what you'll do with the data, will help. It is not difficult for a beginner to learn to use Essbase for the first time. If you have an understanding of how databases work, that will help. Every tool has its own syntaxes and UI, so learning that won't be difficult. Essbase is a pretty stable and good database. The calculation engine is very good. It definitely has some shortcomings, but that's why I would rate it an eight out of ten overall.
It is highly efficient and easily scalable, particularly for handling large databases. When it comes to relational databases, they are a strong choice, scoring nine or even ten out of ten in terms of suitability.
Senior Reg Reporting Consultant at Bank of America
Real User
Top 5
2023-03-27T12:32:49Z
Mar 27, 2023
It is a good product. Also, it receives a patch update from the back end every quarter for maintenance purposes. I recommend the solution and rate it as an eight.
Director, Financial Systems at a retailer with 10,001+ employees
Real User
2022-04-27T08:19:45Z
Apr 27, 2022
Essbase is a powerful tool that continues to provide value for companies. It's also one of the core databases that Oracle uses. I'd rate it as ten out of ten.
Senior Hyperion Consultant at a financial services firm with 10,001+ employees
Real User
2022-01-12T21:38:38Z
Jan 12, 2022
While the product can be used both on the cloud and on-premises, I have not tried the cloud version. I would advise new users to make sure they do very thorough design sessions beforehand instead of just jumping into it. Planning is important in terms of success. I'd rate the solution at an eight out of ten. We've been pretty happy with its capabilities.
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Consultant
Top 20
2016-05-01T10:13:00Z
May 1, 2016
Because Oracle products are development frameworks, your final results is as good as the people who implemented them. Make sure that your implementation team is the best it can be, at least for the first implementation. If something is implemented incorrectly at the start, it'll cost you a lot more to fix than to build a new system from scratch. Sometimes it can be so badly designed that it is impossible to fix. I've been working on implementation for 20 years and I have seen bad implementations everywhere. In fact, I have seen the same tools implemented in the same team by two different people, with one being a success and the other a failure. In the same company, one department says that the tool does not work for them and another says that the tool is the best. The only difference was the implementer. Make sure you get a good team to implement it. The tool has its flaws, but most of time (99%) it is the implementer's fault that you have a bad or slow model.
Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.
If you want to do some analytical processing and you have a huge amount of raw data, Oracle Essbase is a good choice. When you need to analyze the data, transform raw data into consolidated data, do some calculations, and apply Oracle tools to see the hierarchies of the data, Essbase is very effective. For example, if you need to consolidate data from various regions or cities or even on a worldwide or countrywide scale, Essbase is suitable for such analytical operations. There are no other tools that provide as many features for understanding and analyzing data as fast as Essbase. Advice for beginners: As a beginner, there are a few parts you need to understand as basic concepts, like how to build dimensions. If as an end-user, you want to implement this tool in the organization. Then you don't need to worry too much. If you have practical experience with Excel, Smart View is an alternative to access data from Essbase. With Smart View, you can experience the data within Excel and perform some operations without directly using the Essbase application or interacting with the database. Overall rating: I would rate it an eight out of ten for performance and features.
Oracle Essbase is a web integration system that integrates with other data systems. Overall, I rate the solution a ten out of ten.
Before using it, I recommend you check with an expert. We have some EPM administrators who can analyze your requirements and tell you which product is suitable for you. Essbase is the database used in the backend, and in the front end, we have several options like Workspace, Planning, and Enterprise Performance Management reporting tools. The experts can comment on which tools are suitable for you. But if you are looking for some performance management tools, then go for Essbase. There are other competitive tools, like SAP, which can also work. Moreover, the interface is very easy. So, it is easy for a beginner to learn to use Oracle Essabase. Within one or one and a half months, any user familiar with company figures can learn it and implement their forms and everything. Overall, I would rate the solution a nine out of ten.
First, I would like to understand what you want to achieve and what amount of data you are handling. You don't use Essbase for small or medium-sized volumes of data. It is especially used for a large volume of data. Otherwise, people use Anaplan or more cheaper products. Also, the nature of the data you are using and the purpose of the data, like what you'll do with the data, will help. It is not difficult for a beginner to learn to use Essbase for the first time. If you have an understanding of how databases work, that will help. Every tool has its own syntaxes and UI, so learning that won't be difficult. Essbase is a pretty stable and good database. The calculation engine is very good. It definitely has some shortcomings, but that's why I would rate it an eight out of ten overall.
It is highly efficient and easily scalable, particularly for handling large databases. When it comes to relational databases, they are a strong choice, scoring nine or even ten out of ten in terms of suitability.
It is a good product. Also, it receives a patch update from the back end every quarter for maintenance purposes. I recommend the solution and rate it as an eight.
I rate the solution an eight out of ten. The solution is good, but it could be cheaper. I recommend the solution to other users.
We use both cloud and on-premises deployments of the product. I'd rate the solution eight out of ten. We've been happy with the product overall.
Essbase is a powerful tool that continues to provide value for companies. It's also one of the core databases that Oracle uses. I'd rate it as ten out of ten.
While the product can be used both on the cloud and on-premises, I have not tried the cloud version. I would advise new users to make sure they do very thorough design sessions beforehand instead of just jumping into it. Planning is important in terms of success. I'd rate the solution at an eight out of ten. We've been pretty happy with its capabilities.
Because Oracle products are development frameworks, your final results is as good as the people who implemented them. Make sure that your implementation team is the best it can be, at least for the first implementation. If something is implemented incorrectly at the start, it'll cost you a lot more to fix than to build a new system from scratch. Sometimes it can be so badly designed that it is impossible to fix. I've been working on implementation for 20 years and I have seen bad implementations everywhere. In fact, I have seen the same tools implemented in the same team by two different people, with one being a success and the other a failure. In the same company, one department says that the tool does not work for them and another says that the tool is the best. The only difference was the implementer. Make sure you get a good team to implement it. The tool has its flaws, but most of time (99%) it is the implementer's fault that you have a bad or slow model.