Like Oracle Olap, Hyperion Essbase stores its data in a specially optimized multidimensional data store, but unlike Oracle OLAP, stores it outside of a relational database engine, usually on its own dedicated server.
With the latest release of Oracle OLAP, organizations typically use it for adding analytics and advanced calculation capabilities to their Oracle data warehouse, whereas Hyperion Essbase is typically used in heterogeneous environments that need to support :
- a range of database,
- business intelligence,
- and planning and forecasting tools.