Oracle Essbase Integration Services—an optional product component—provides a metadata-driven environment to bridge the gap between data stored in database and detailed data stored in relational databases.
It was the first major effort to bring together the power of Essbase with details stored in relational databases, was Essbase Integration Server (“EIS”) (used by less than 10% of Essbase customers to provide drill-through). From the release 11.1.1, Essbase Studio was introduced to replace it.
Oracle Essbase Integration Services provides a suite of graphical tools that can be used to create:
To create OLAP models or build metaoutlines, you must connect Integration Services to a database that contains metadata (the Essbase - Integration Services - OLAP Metadata Catalog database).
Hybrid Analysis allows portions of database to be stored in a relational database. This relational-stored data is mapped to the appropriate Essbase hierarchies.