Oracle Essbase Studio
Oracle Essbase

Simplify Essbase cube deployment
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.

Wizard driven user interface
Oracle Essbase Studio provides an easy-to-use graphical modeling environment. Essbase Studio provides the cube building functionality previously provided in Essbase Integration Services for cube creation and management.

Catalog for storing metadata
The Essbase Studio Catalog is a common metadata repository 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.

Support for a variety of datasources
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.

Drill-through reports
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.

Lineage Diagrams for impact analysis
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.


Products / Options
 Oracle Essbase Studio
 Oracle Essbase Administration Services
 Oracle Essbase Integration Services
 Oracle Essbase Provider Services


What's New


Oracle Essbase Studio  11.1.2.3 Release Highlights


Lifecycle Management (LCM)
The Essbase Studio catalog can be migrated using the LCM feature available in the Shared Services console.

Teradata Connection properties
Teradata connection properties can be set in the server.properties configuration file.

 

Oracle Essbase Studio 11.1.2.2 Release Highlights

 
Essbase Model Resync
Using the new “Update Out-of-sync Models” option, you can pick and choose which models to sync, without having to recreate them or reset properties.

New Streaming Option in Cube Deployment Wizard
A new check box, “Enable streaming mode for cube deployment” has been added to the first page of the Cube Deployment Wizard. This new option allows users to select to deploy cubes in streaming or nonstreaming mode. The selection is made each time you deploy or redeploy.

Minischemas Now Part of Data Source Connection
Minischemas have been reimplemented in this release to associate them with data source connections.

Alias Set Enhancements
In this release, all tasks related to alias set creation and maintenance become accessible directly in the Metadata Navigator.

Streamlined Modeling of Oracle BI EE Business Model Sources
Essbase Studio now lets you create a cube schema and Essbase model during the data source connection creation process.

Support for Oracle RAC Data Sources
You may now create and edit data source connections to Oracle Real Application Cluster (RAC) sources. In the Connection Wizard, you enter an Oracle Service Name, and then you can enter multiple Oracle RAC server nodes per connection.

Hosted Online Help
Online Help content for Oracle Enterprise Performance Management System products is served from a central Oracle download location, which reduces the download and installation time for EPM System. You can also install and configure online help to run locally.
 

Oracle Essbase Studio 11.1.2.1.102 Release Highlights


Redeployment in Background Option for XOLAP Cubes
You now have the option of redeploying XOLAP cubes in the background.

Support for Incremental Update of XOLAP Cubes
Essbase Studio now supports incremental update for XOLAP cubes.
 

Oracle Essbase Studio 11.1.2.1 Release Highlights


Essbase Studio Server and Catalog Upgrade
This release allows you to upgrade your Essbase Studio installation from an earlier release, keeping all information in the Essbase Studio catalog intact and functional.

Oracle BI EE Business Model Support
Essbase Studio now supports Oracle Business Intelligence Enterprise Edition Business Model as a data source. In previous releases, Oracle BI EE support was limited to Presentation Layer.

SSL Support for Essbase Studio Server Connections
Essbase can be deployed to work in Secure Socket Layer (SSL). In SSL mode, all communication between Essbase Server and Essbase Studio Server is encrypted to ensure data security.
 

Oracle Essbase Studio 11.1.2.0 Release Highlights


Essbase Studio Server as a Windows Service- Essbase Studio Server can be installed as a Windows Service.

Essbase Studio Catalog Export and Import- Essbase Studio now provides an option to export/ import the catalog into via XML file for administrative purposes, such as backup or moving the catalog from one machine to another.

Improved Data Source Exploration- Essbase Studio will no longer need to lock the catalog during the data source exploration process.

Oracle Diagnostic Logging (ODL)- Essbase Studio logging now uses the Oracle Diagnostic Logging (ODL) framework.

Support for ODBC DSN and OCI Connections- During cube deployment, you can specify ODBC DSNs or Oracle Call Interface (OCI) connection information.

Connection Pooling- With connection pooling, the query driver in Essbase Studio provides a pool of physical connections per data source, allowing the execution of concurrent queries, and speeding up query processing.

Support for Connections to Essbase Server Clusters- Essbase Studio allows you to create connections to Essbase Server clusters.

Enhanced Data Source Synchronization- You can keep your Essbase Studio data source connections closely synchronized with the physical data source using the Delete and Refresh table commands available in the Data Sources tab of the Source Navigator.

Deleting Tables- Remove tables that are no longer in use or that you do not want used with a particular data source connection.

Refreshing Tables- Refresh tables to detect schema changes that occurred in your data source since you created the data source connection.

Improved title bar information- The title bar of the Essbase Studio Console now displays the Essbase Studio Server name, the logged-in user name, and the logged-in user role.

Increased Limit for Alias Tables- Essbase Studio now supports 32 alias tables for block storage and aggregate storage databases as supported by Essbase 11.1.2.0.

Text List Mapping Support- This release introduces a new metadata element for defining text lists.

Essbase Model Design Improvements- Essbase model design changes have resulted in improved Essbase model handling of specific changes to metadata elements and cube schemas. For example, in previous releases, changing a hierarchy name meant that you had to recreate or rebuild any Essbase models in which that hierarchy participated.
Starting with this release, recreating or rebuilding an Essbase model is not required when you perform the following operations on a metadata folder, dimension element, derived text measure, text list, hierarchy, measure hierarchy, or cube schema:
    Rename
    Move
Further, recreating or rebuilding an Essbase model is not required when you perform these operations:
    Change the binding, filter, sort order, or alias set bindings of a dimension element
    Change the binding, range, or alias set bindings of a derived text measure
    Change the value binding or ID binding of a text list
    Change an overridden data load binding in a cube schema
Note that recreating or rebuilding an Essbase model is required when you perform the following operations:
    Reorder, add, or remove members in a hierarchy or measure hierarchy
    Add or remove hierarchies from a cube schema
    Add or remove any loose measures in a cube schema
    Change the measure hierarchy in a cube schema
    Override the default data load bindings in a cube schema

Dimension Sort Order Support- Essbase Studio supports dimension sort order. Dimension sort order determines the order that dimensions appear in the Essbase model and subsequent Essbase outline and, in turn, impacts the order that dimensions are calculated.

Support for Named Generations and Levels- You can now create your own names for generations and levels in an Essbase model.

Automatic Placement of Actual Member Before Shared Members- For aggregate storage outlines, Essbase requires that actual members are always placed before shared members. After building your Essbase outline, you may have placed shared members before actual members in recursive dimensions. By selecting a new check box in the Outline Build tab of the Essbase Model Properties dialog box, the first instance of an outline member name becomes the actual member instance. Any other instances of that outline member name become the shared members.

MaxL Deployment Script Generation- When performing a cube deployment, you can save all the deployment parameters and options you have chosen as a MaxL script. Then, depending on the options you chose when creating the script, you can use this script in the MaxL Shell to perform member or data loads, or both.

Improved Deployment status information- A window now displays when you launch a cube deployment, and stays onscreen when deployment is completed. The window includes the following information about the cube deployment:
        Member load and data load start time
        Status message listing member and data load details
        Elapsed time, in minutes and seconds, of member loads and data loads
        Number of records processed and records rejected
        Deployment success or failure
        Location of the error file

Drill-through on Recursive Hierarchies- Essbase Studio now provides support for drill-through reports built on recursive hierarchies.

Lineage Viewer Display Improvement- When the caption binding and key binding are the same, only one node is displayed for the physical element in the Lineage Viewer.

Cancellation Option for Integration Services Catalog Migration- You may cancel an Oracle Essbase Integration Services catalog migration while it is in progress.

Accessibility- In this release, the Essbase Studio user interface adds keyboard-only support to all applicable dialog boxes and screen elements, as well as screen reader support.


Oracle Essbase Studio, Fusion Edition V.11.1.1 Release Highlights


Discussions | See All
Financial ConsolidationPlanning and BudgetingOracle Essbase
Re: difference between parent ...
Jun 18, 2010
by: kostasn
 
Re: Taskflows disappear in 'Ma...
Jun 17, 2010
by: Graafmans
 
difference between parent curr...
Jun 17, 2010
by: mayanka bhusan
 
HFM Journal Report in PDF
Jun 17, 2010
by: user3573727
 
Re: HFM setting - UseStickySer...
Jun 17, 2010
by: CBarbieri
 
Re: Ask Reconfigure Database P...
Jun 18, 2010
by: Arifuddin
 
Re: Help in Data forms
Jun 17, 2010
by: tvmk
 
Re: The behavior of aggregatio...
Jun 17, 2010
by: Alp Burak
 
The behavior of aggregation of...
Jun 17, 2010
by: user2257134
 
Re: Ask Reconfigure Database P...
Jun 17, 2010
by: Arifuddin
 
Re: installation of 11.1.2 ver...
Jun 18, 2010
by: user617184
 
Re: Very long calculation
Jun 18, 2010
by: bocharova
 
Re: Very long calculation
Jun 18, 2010
by: bocharova
 
Re: Partition failing
Jun 17, 2010
by: Krishna DPR
 
Re: restructuring process
Jun 17, 2010
by: Srinivas Bobbala