We performed a comparison between Oracle Essbase, Oracle OBIEE, and SAP Analytics Hub 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."I have found the most valuable aspect is the user-friendly environment and current features."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"The solution can handle a large volume of data."
"The solution is stable and reliable."
"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."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is scalable."
"Ability to create our own reports."
"The setup isn't too difficult."
"It is a stable and scalable solution."
"The most valuable feature of Oracle OBIEE is interactive reporting because it allows better analysis versus conventional reporting, especially on the data warehouse side."
"I think having the conformed structures makes it a lot easier for end users and pulling reports together."
"It's easy to create fully-functional Dashboards."
"Scalability-wise, I rate the solution a nine out of ten...The solution's initial setup was straightforward."
"The solution is user-friendly."
"For report scheduling, I always prefer SAP because it has the most powerful scheduling features, like sending reports to more than 1,000 customers per day. That option is not as good in Microsoft BI and in Tableau it only exists as an add-on option."
"This product provides good reports using a single pane of glass."
"What I like best about this solution is that it is built into the SAP line, making it easier to integrate with other SAP products."
"SAP Analytics Hub offers a user-friendly interface with effortless configuration, seamless updates, and real-time availability of information. It avoids the complexities associated with batch processing, providing a smooth and efficient experience."
"Data consistency is also a notable feature; the system takes care of data consistency, so you don't need to handle it manually."
"The initial setup could be simplified."
"The reporting tool of Essbase needs improvement."
"They should improve the solution's performance."
"There is room for improvement in terms of cost-effectiveness."
"The initial setup is pretty complex."
"The ability to drive external reporting out for development could be improved."
"I would like to see an integration with application performance management and a version control management tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"There could be better integration with other solutions, such as Microsoft Office."
"This solution is weak in the data science perspective. I have past data science experience. And, I find that there is a lot of room for improvement in terms of incorporating more advanced statistical modeling into the product."
"The performance could be better."
"The development effort takes longer than other BI tools currently on the market."
"One feature I would definitely like to see is the ability to provide the in-memory data. Oracle might have some plugins but, as of now, that feature isn't available out-of-the-box. You might have to purchase that feature."
"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."
"From the point of view of strategic management, I would like to have a feature, perhaps a form after we get to the KPI dashboard, to be used to note if something unusual happens in the operations. That way we could record extreme KPI situations, and track why a number is very low or too high."
"n the beginning it had it's stability issues, but it became stable."
"Faster implementation of new functions for the new product is an area of improvement in SAP Analytics Hub."
"The interface can be simplified because it is not a user-friendly experience."
"Pricing and support are integrated into the system. However, the support process can be challenging, particularly when navigating the SAP support site, which lacks user-friendliness and ease of access."
"The analytics part of SAP has not been that good up until now. They're still in the infant stage and development is still going on. SAP has some cloud analytics and they're trying to configure it in Lumira, but it's not that good at this point."
"The technical support for Analytics Hub is limited and could be improved."