Oracle® Essbase

New Features


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

Authors: EPM Information Development Team

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, then the following notice is applicable:


Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

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.

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

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about 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 unless otherwise set forth in an applicable agreement between you and Oracle. 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, except as set forth in an applicable agreement between you and Oracle.

Table of Contents:

Essbase New Features

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.

Thread Pool for Parallel Operations

Historically, Essbase dynamically created threads for parallel operations such as parallel calculation, parallel data load, and parallel restructure. However, beginning this release, the following parallel operations do not dynamically create threads, but instead use a set number of threads from a pre-created pool of threads:

  • Parallel calculation, with CALCPARALLEL or FIXPARALLEL

  • Parallel data load, for aggregate storage and block storage databases

  • Parallel export, for block storage databases

  • Parallel restructuring

You can customize the size of the thread pool. For more information, see the WORKERTHREADS configuration setting topic in the Oracle Essbase Technical Reference.

XML Outline Editing

XML outline editing enables you to use an XML file to make basic changes to the database outline. This method is a streamlined way to make outline edits without needing to use a rules file nor invoke the Outline API. To perform XML outline editing, you reference a provided .xsd file, create an .xml file, and call the C Main API function EssBuildDimXML (or the Java API method buildDimensionXml). For more information, see EssBuildDimXML in the Oracle Essbase API Reference.

To use the XML outline editing feature in Essbase, aggregate storage outlines that were created in an earlier release must first be migrated to

Enhancements to Hybrid Aggregation

Hybrid aggregation mode was introduced in Release as a way to bring improved calculation efficiency to block storage databases. In this release, Time-balance tagged members and Dynamic Time Series members can also be calculated in hybrid aggregation mode.

Additionally, many more calculation functions are included in the list for member formulas that can be calculated in hybrid aggregation mode. For the full list, see the topic “Functions Supported in Hybrid Aggregation Mode” in the Oracle Essbase Technical Reference.

For more information about hybrid aggregation mode, see the ASODYNAMICAGGINBSO configuration setting topic in the Oracle Essbase Technical Reference.

Optimizations for Oracle Exalytics In-Memory machine

Enhancements have been introduced for Essbase Server running on Oracle Exalytics In-Memory machine. An accompanying increase in virtual memory usage is normal and expected. Virtual memory usage is increased by the size of page files.

On SPARC T5/Solaris Exalytics In-Memory machine, for best performance, configure swap space on the system to be greater than the sum of the expected sizes of dynamic calculator caches, for all databases on the system.

Supporting POV and Pivot Enhancements for Smart View

Essbase and Oracle Hyperion Provider Services are enhanced to support the Oracle Smart View for Office Point of View (POV) toolbar and pivoting behavior as follows:

  • Multiple members can be pivoted from the grid to the POV toolbar.

  • Multiple members can be pivoted from the POV toolbar to the grid.

  • A single dimension can remain on the POV toolbar.

In prior releases, only one member in a dimension could be pivoted from the grid to the POV, and from the POV to the grid. Also in prior releases, Essbase and Oracle Hyperion Provider Services only supported having at least two dimensions on the Oracle Smart View for Office POV toolbar.

Calculation Enhancements

New Calculation Functions

@RELXRANGE—Generates a cross dimensional list based on the relative position of the cell that is currently being calculated and the offsets.

Calculation Function Changes

Support for the XrangeList parameter is added to a number of functions. XrangeList is a range of members from one or more dimensions, and can help you incorporate time continuum navigation. The functions that support XrangeList are:




  • @COUNT





  • @IRR

  • @IRREX


  • @MODE

  • @NEXT

  • @NEXTS

  • @NPV

  • @PRIOR


  • @PTD

  • @RANK

  • @RELXRANGE (new function)

  • @SHIFT



  • @SLN

  • @SYD



Configuration Setting (essbase.cfg) Changes

New Configuration Settings

  • WORKERTHREADS—See Thread Pool for Parallel Operations.

  • CRASHDUMPLOCATION—Sets the location where Essbase saves a core dump file when an abnormal termination occurs.

  • CONNECTIONTIMEOUT—Specifies the maximum time that Essbase should wait for a SQL connection before timing out.

  • QUERYTIMEOUT—Specifies the maximum time that Oracle Essbase should wait for a SQL query to execute before timing out.

MaxL Grammar Changes

The MaxL export data statement includes grammar you can use to make exported data anonymous, wherein real data is replaced with generated values. This removes the risk of sensitive data disclosure, and can be used in case a model needs to be provided to technical support for reproduction of certain issues.

Essbase API Changes

New C Main API Function

EssBuildDimXML—See XML Outline Editing.

New C Outline API Function

EssOtlVerifyOutlineEx3—A new API function for verifying outlines. This function differs from EssOtlVerifyOutlineEx in that it provides both member warnings and formula errors.

Changed API Functions and Structures

ESS_PERF_CUSTCALC_T and ESS_PERF_ALLOC_T have an additional field, dataloadOption. Generated calculation or allocation values can be added to existing values, instead of overwriting them.

Features Introduced in Earlier Releases

Use the Cumulative Feature Overview tool to create reports of new features added in prior 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: