Essbase - Studio

Essbase Studio Overview


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 :

  • Relational databases,
  • Essbase applications (drill across),
  • OBIEE, BI+ reports,
  • Reporting and Analysis repositories,
  • URL-based,
  • custom SQL,
  • and custom Java Methods with report based on any member selection that is defined in the data source

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.

How to schedule cube deployment

There are two ways to schedule cube deployment outside of Essbase Studio:

  • You may create a deployment script that uses the MaxL “deploy” command. Then, use a scheduling tool of your choice to schedule the script to run.
  • Alternatively, you can create rules files using the Essbase Studio Console or the MaxL “deploy” command with the rules files only option. Then, create a deployment script that uses the MaxL “import data” command using the pre-created rules to automate cube construction. Again, use a scheduling tool of your choice to schedule the script to run.

Discover More
Edelivery File
EPM 11g - Windows Installation (Essbase

If you install it on a DHCP computer : clean up environment variable for Essbase (as ) Download the following files from the “Oracle Enterprise Performance Management System” page of the...
Administration Services Architecture
Essbase - Administration Services Console

Administration Services Console is the common graphical user interface (GUI) of that enables administrators to manage the Essbase environment from one navigation tree, called . essbase studio The console...
Essbase Architecture Overview
Essbase - Architecture/Components

Figure below provides a high-level view of the information flow between the three tiers of the Essbase architecture : (on the left) (in the center) (on the right) The client tier includes...
Essbase Overview
Essbase - Clients

The client tier of the are : for Office, Fusion Edition, , Fusion Edition. an MDX query, or Report Writer. You can install them separately of the server installation....
Essbase Overview
Essbase - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
Essbase Overview
Essbase - Getting Started - Tutorial

Oracle by Example Documentation Oracle...
Essbase Client
Essbase - How to install the Essbase Client Software ?

To install the following client (console) software: Just follow the same guideline that the normal installation but choose only the client tiers as shown in the next picture.
Essbase Overview
Essbase - Integration Services (EIS)

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....
Essbase Overview
Essbase - Sample Applications

Essbase provides a set of sample applications and associated databases that you can use to learn Essbase features, and which are the basis for many of the examples given in the documentation. Sample...
Essbase Overview
Essbase - Sample Data Source TBC (The Beverage Company)

TBC (The Beverage Company) is a database for a fictitious company of Essbase. It's used for sample purpose with : integration service : How to set up the TBC sample application ? Connect as...

Share this page:
Follow us:
Task Runner