Essbase Studio Overview

Essbase Studio Overview

Essbase Studio is use for cube construction through single environment for performing tasks related to data modeling, cube designing, and analytic application construction. Consolidating cube construction activities into one interface, Essbase Studio provides a consistent platform for building outlines and loading data. Essbase studio is an user interface, Essbase Studio supports modeling various data source types from which Oracle Essbase applications are typically built, making it a single point from which all cube-related data modeling can be performed.

Essbase Studio supports several drill-through options:

1.      Relational databases

2.      Oracle Business Intelligence Enterprise Edition

3.      URLs

4.      custom SQL

5.      Java methods

Drill-through functionality is supported from data cells and member cells and is dynamically linked to cubes with matching metadata context.

Essbase Studio User Interface

The Essbase Studio user interface consists of three dockable main areas:

1.      Source Navigator, described in

2.      Work Area, described in

3.      Metadata Navigator, described in

Additionally, you can choose to display or dock Console Messages.

Source Navigator

The Source Navigator, displayed by default in the right pane of the Essbase Studio Console, has two tabs, the Data Sources tab and the Minischemas tab.

1.  Data Sources tab—Lists the physical data sources to which you have created connections. You can also launch the Connection Wizard from this tab, where you create data source connections.

2.      Minischemas tab—Lists the graphical representations of the tables you select from one or more data sources connections. You can create Minischemas when creating data source connections, or you can create them later.

Work Area

The work area, by default in the middle pane of the Essbase Studio Console, is used to display and work with metadata elements and graphical representations of source and metadata elements.

Objects displayed in the work area:

1.      Minischemas

2.      Essbase models

3.      Lineage View

4.      Drill-through reports

5.      Hierarchy editor

6.      Sample data

7.      Deployment history

Metadata Navigator

Metadata elements derived from the physical data sources when you create a data source connection. Each time you create a new data source connection, you can create metadata elements from the physical elements in the data source to which you have connected. These metadata elements are displayed by default in a folder structure that mimics the tables and columns in the data source.

Metadata elements that you create from the derived metadata artifacts in the Metadata Navigator.

From the derived metadata artifacts you can further create metadata elements such as:

Folders

1.      Dimension elements

2.      Derived text measures

3.      Standard hierarchies

4.      Measure hierarchies

5.      Calendar hierarchies

6.      Cube schemas

7.      Essbase models

8.      Drill-through reports

These metadata elements are used to create cube schema and models that work with Essbase.

Essbase models are used to create and deploy Essbase cubes.