No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions

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.

Catalog for storing metadata

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

What's New

Oracle Essbase Studio Release Highlights

Connecting to Alternate Data Sources for Drill-through Reports

When running a drill-through report, you can connect to an alternate data source. An alternate data source is a data source other than the one that was used to create the Oracle Essbase cube.

Requiring a User Name and Password to Perform Drill-through

You can require users to enter a user name and password to access the database when performing drill-through. When you select Require user name and password on the Report Contents tab of the drill-through report editor, Oracle Smart View for Office users must enter a user name and password to access the database during drill-through.

Clearing Deployment History from Essbase Studio Console

In Metadata Navigator, you right-click the Essbase model and select Deployment History and then Clear Deployment History.

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

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

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:



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