We performed a comparison between Oracle Essbase, Oracle OBIEE, and Pyramid Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."The solution is stable and reliable."
"The solution can handle a large volume of data."
"Essbase is extremely stable and low-maintenance."
"The solution is scalable."
"It helps us fetch specific data sets per users' requirements."
"It is highly efficient and easily scalable, particularly for handling large databases."
"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."
"I have found the most valuable aspect is the user-friendly environment and current features."
"Scalability-wise, I rate the solution a nine out of ten...The solution's initial setup was straightforward."
"The most valuable feature is the reporting."
"I think having the conformed structures makes it a lot easier for end users and pulling reports together."
"The scalability of the product is good."
"The security is good. For example, we can implement column-level security."
"Ability to create our own reports."
"The most valuable feature is the ability to run it in Exalytics within memory coupled to a Repository on Exadata is where it flies. So it's not meant for mom and pop shops, but if you are a global 500 fortune 1000 company, this is a tool that can get you what you need on time and even in real time."
"The solution offers a wide range of software tools to meet various needs, such as those concerning reports, developer solutions like APEX and the integration of data."
"The on-premise version has quite good scalability."
"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"I think the most valuable Pyramid Analytics feature is the solution's ability to drill down and dice in the loop. I think it is better than InExcel or Power BI."
"It offers a wide range of analytics options including statistics and visualizations, as well as prediction capabilities, allowing users to make forecasts based on the latest data."
"It proved to be a very powerful and useful tool due to its breakdown capabilities, easy reporting features, flexibility in building custom calculations, and the ability to integrate them into reports."
"Pyramid has a wide level of uses, as it's a complete ETL process and has a good level of connecting to a lot of data sources."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"It's an expensive product to use."
"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."
"There is room for improvement in terms of cost-effectiveness."
"The ability to drive external reporting out for development could be improved."
"They should improve the solution's performance."
"The initial setup could be simplified."
"I would like to see an integration with application performance management and a version control management tool."
"The initial setup is pretty complex."
"I would like to see the data wrangling features enhanced."
"The performance could improve and in a future release, they could provide more virtualization options."
"BI Server"
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"When a large number of queries are running at the same time, the report fails."
"It should have more self-service capabilities."
"Oracle products have a lot of complications...Oracle has a history of not really providing great support."
"Retail, Finance, Wholesale"
"I find that this is quite a heavy, time-consuming tool for developers."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"There is room for improvement in terms of the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
