Prior to release 11.1.1, users could create links to transactional data in relational datawarehouse by using a suite of tools called Essbase - Integration Services (EIS).
Release 11.1.1 introduces Essbase Studio.
Combining into a single workbench much of the functionality of :
Essbase Studio is the next-generation environment for the development, deployment, and maintenance of enterprise-scale application
Oracle Essbase Studio consolidates cube-construction activities into one interface, enabling consistent performance for data load and dimension build.
Essbase Studio simplifies cube construction by delivering a single environment for performing tasks related to data modeling, cube designing, and analytic application construction.
The graphical front-end features of Essbase Studio enable you to build Essbase Cubes from snowflake and star schema relational data source and flat files.
Essbase Studio features a built-in repository that enables you to store and reuse metadata elements and Essbase - Hierarchies in multiple cubes.
Lineage tracking functionality in Essbase Studio provides full upstream and downstream metadata visibility for your Essbase - Data Source. Additionally, it provides enhanced drill-through to multiple targets including :
With a wizard-driven user interface, Essbase Studio supports modeling of the various data source types from which applications are typically built.
A single common metadata repository, or catalog, captures all metadata related to all Essbase applications built in the enterprise and allows the reuse of metadata at the lowest level of granularity. The catalog makes Essbase Studio inherently aware of the common metadata that is shared across the various applications enterprise wide.
Essbase Studio also supports lineage tracking through a rich graphical view of metadata relationships, allowing users to follow application lineages to their metadata components and through to the data sources from which they were sourced.
There are two ways to schedule cube deployment outside of Essbase Studio: