Oracle Essbase Studio is a single environment to simplify the construction and administration of Essbase applications. Essbase Studio provides a single interface for performing tasks related to data modeling, cube design, and construction of analytic applications. Essbase Studio provides a consistent platform for building outlines and loading data by consolidating cube construction activities into one interface. Essbase Studio is a new module with the EPM System 11.1 Release.

With a wizard-driven user interface, Essbase Studio provides an easy-to-use graphical modeling environment. Essbase Studio combines the cube building functionality previously provided in Essbase Integration Services and Essbase Administration Services into a single environment for integrated cube creation and management.

A common metadata repository, or catalog, captures all metadata related to all Oracle Essbase applications built in the organization and allows the reuse of metadata at the lowest level of granularity. The catalog gives Studio knowledge of the common metadata that is shared across the various Essbase applications deployed enterprise-wide. This knowledge allows the ability to trace the use of elements (dimensions, data sources, members, etc) across your full deployment, allows the highest degree of reusability at the most granular level, and provides for instant accessibility to new drill through reports for any cubes sharing the required artifacts. The result is to promote the re-use of metadata objects and improve consistency across all applications.

Essbase Studio is a single environment to update data source administration and access and supports the modeling of Essbase cubes from relational databases, OBI Suite EE, flat files, and the Dimension Server Library in EPM Architect. In addition, Essbase Studio supports several drill-through options: relational databases, Oracle Business Intelligence Enterprise Edition, URLs, custom SQL, and Java methods. Drill-through functionality is supported from data cells and member cells and is dynamically linked to cubes with matching metadata context with no interruption to application up time.

Essbase Studio helps organizations manage change through impact analysis and determine the data lineage of the metadata artifacts. With the support for lineage tracking through a rich graphical view of the metadata relationships, Essbase Studio allows users to follow application lineages to their metadata components and through to the data sources from which they were sourced. Essbase Studio supports multiple end-user roles and each role has its own access privileges on various types of studio catalog objects.