Oracle® Essbase

New Features


Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Updated: December 2013

Authors: EPM Information Development Team

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:


Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Table of Contents:

Essbase New Features

Documentation Now Certified on Apple Mobile Devices

Features Introduced in Earlier Releases

This document describes the new features in Oracle Essbase Release For detailed information on these features, see the Oracle Essbase Database Administrator's Guide, Oracle Essbase Technical Reference, and Oracle Essbase API Reference.

For information about the new features in Oracle Essbase Administration Services, see the Administration Services Readme.

Using Runtime Substitution Variables in Calculation Scripts

Similar to substitution variables, a runtime substitution variable can be included in a calculation script wherever substitution variables are allowed. Runtime substitution variables are different from substitution variables in that every runtime substitution variable used in a calculation script must be declared in the SET RUNTIMESUBVARS calculation command. In SET RUNTIMESUBVARS, the name of a runtime substitution variable is required. Specifying a default value for the runtime substitution variable is optional. At runtime, values can be provided for runtime substitution variables that do not have a default value, and default values that are specified in the SET RUNTIMESUBVARS command can be overwritten using MaxL or the Essbase API.

Runtime substitution variables are supported for block storage databases only.

Optimizing Name Lookup and Insertion During Dimension Build and Outline Editing

A new hashtable implementation optimizes the performance of name lookup and insertion when building dimensions and editing outlines. This hashtable implementation has an increased memory footprint.

To configure the hashtable, use the ESTIMATEDHASHSIZE configuration setting. This setting specifies, in millions, the estimated number of member name and alias name strings that are loaded into memory.

The ESTIMATEDHASHSIZE configuration setting applies to block and aggregate storage applications.

Unique Names for Shared Members

In grid clients (for example, Oracle Hyperion Smart View for Office), you can reference shared members as unique from their base members by typing them with a qualified name (for example, [Parent].[Child]). Shared members can be referenced with qualified names even if you have not set the outline to enable duplicate member names.

Customizing Teradata TPT-API Load Settings

When using the Teradata TPT-API for data load, you can customize settings that provide greater flexibility while loading data through the TPT-API. For more information, see Appendix A in the Oracle Essbase SQL Interface Guide.

Calculation Enhancements

New Calculation Functions

  • @CREATEBLOCK—Creates a block for a sparse member name or a sparse member combination and sets dense values in the newly created block to #MISSING.

  • @INTERSECT—Returns the intersection of members that appear in two specified lists of members.

  • @ISMBRUDA—Returns TRUE if the specified user-defined attribute (UDA) exists for the specified member at calculation time.

  • @ISRANGENONEMPTY—Tests for the existence of data values to improve performance of complex dense processing. If this function returns true, values exist for the specified range. If it returns false, the range is empty.

  • @MEMBERAT—Returns the specified member in a list of members.

  • @RANGEFIRSTVAL—Returns the first value, in a range of the specified mbrList, that satisfies the criterion specified in the first function parameter.

  • @RANGELASTVAL—Returns the last value, in a range of the specified mbrList, that satisfies the criterion specified in the first function parameter.

Calculation Function Changes

The @NAME calculation function has a new, optional argument, UNIQUE, which tells @NAME to return a unique member name (using shortcut qualified name format) for mbrName, if mbrName is a duplicate name. If mbrName is not a duplicate name or if duplicate member names is not enabled, UNIQUE is ignored, and only the member name is returned.

New Calculation Command

SET RUNTIMESUBVARS—Declares runtime substitution variables that are used in a calculation script.

Configuration Setting (essbase.cfg) Changes

New Configuration Settings

  • ENABLERTSVLOGGING—Determines whether Oracle Essbase logs runtime substitution variables that are used in a calculation script.

  • ESTIMATEDHASHSIZE—Specifies, in millions, the estimated number of member name and alias name strings that are loaded into memory.

  • UNICODEENABLE—Enables Essbase Server to create Unicode-mode applications and to migrate applications to Unicode mode, without needing to set the Essbase Server to Unicode mode using Oracle Essbase Administration Services, MaxL, or the API.

Deprecated Configuration Settings



MaxL Grammar Changes

The execute calculation MaxL statement has new grammar: with runtimesubvars RTSV-LIST. This grammar executes a calculation script with the specified runtime substitution variables, which are specified as a string of key/value pairs.

Essbase API Changes

New C Main APIs

  • EssCalcFileWithRuntimeSubVars—Executes a calculation script against the active database with the specified runtime substitution variables. Runtime substitution variables can be specified in a text file (with a .rsv extension) or as a string of key/value pairs

  • EssCalcWithRuntimeSubVars—Executes a calculation script with the specified runtime substitution variables, which are specified as a string of key/value pairs.

  • EssGetRuntimeSubVars—This function is implemented as an interface to a client in which a calculation script is run. This function retrieves all of the information (name, value, and description) that is specified in the runtime substitution variable declarations in the SET RUNTIMESUBVARS calculation command for a specified calculation script.

New C Main Structures

ESS_RUNTIMESUBVARS_DESC_T—Used by EssGetRuntimeSubVars API. This structure is the data type for the RTSV-LIST argument, which is a list (array) of runtime substitution variable structures in the calculation script.

Documentation Now Certified on Apple Mobile Devices

Documentation files for Release are now available in two mobile formats: MOBI files, available previously, and EPUB files. Oracle Enterprise Performance Management System EPUB documentation files are supported on all Apple Mobile devices (iPad, iPhone, and iPod Touch). EPUB files are supported on many mobile devices; however, they are certified only on Apple Mobile devices. Additional devices will be certified over time.

Features Introduced in Earlier Releases

If you are coming from Release,, or, use the Cumulative Feature Overview tool to review the list of new features added between those releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here: