Oracle Essbase Studio Oracle Essbase 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.

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.1 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

• What's New in Oracle Essbase Studio Release 11.1.1.0?

Discussions | See All
Financial Consolidation	Planning and Budgeting	Oracle 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