We performed a comparison between Oracle Essbase 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."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."
"The solution is stable and reliable."
"Essbase is extremely stable and low-maintenance."
"The solution can handle a large volume of data."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It helps us fetch specific data sets per users' requirements."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is scalable."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"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 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."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"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."
"The on-premise version has quite good scalability."
"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."
"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."
"I would like to see an integration with application performance management and a version control management tool."
"It's an expensive product to use."
"They should improve the solution's performance."
"There is room for improvement in terms of cost-effectiveness."
"The ability to drive external reporting out for development could be improved."
"The initial setup is pretty complex."
"The initial setup could be simplified."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"I find that this is quite a heavy, time-consuming tool for developers."
"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."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
Oracle Essbase is ranked 10th in Database Development and Management with 10 reviews while Pyramid Analytics is ranked 16th in BI (Business Intelligence) Tools with 8 reviews. Oracle Essbase is rated 8.4, while Pyramid Analytics is rated 7.6. The top reviewer of Oracle Essbase writes "It is easy to use and receives patch updates on regular intervals ". On the other hand, the top reviewer of Pyramid Analytics writes "A comprehensive and user-friendly business intelligence for enhanced data insight". Oracle Essbase is most compared with Microsoft Power BI, SAP BusinessObjects Business Intelligence Platform, SAP Analytics Cloud, Oracle Analytics Cloud and Tableau, whereas Pyramid Analytics is most compared with Microsoft Power BI, Tableau, Alteryx, Databricks and Qlik Sense.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.