Oracle® Essbase Administration Services

New Features


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

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:

Administration Services Release New Features

Administration Services Release New Features

Administration Services Release New Features

Administration Services Release 11.1.2 New Features

This document describes the new features in Oracle Essbase Administration Services Releases 11.1.2,,, and For more information about these features, see the Oracle Essbase Administration Services Online Help.

For information about the new features in Oracle Essbase, see the Oracle Essbase New Features.

Administration Services Release New Features

Filters Listed in Alphabetical Order

Filters listed in dialog boxes in Administration Services are now sorted in alphabetical order.

UNC Path Support

When working with Essbase clusters to achieve high availability of servers, it is customary to use network file systems for sharing the Essbase application files across systems.

On Windows, you can use Universal/Uniform Naming Convention (UNC) to describe the location of a network resource, such as a shared directory. Syntax:


For Essbase and Administration Services running on Windows, UNC paths are supported to specify network shared paths for the following Essbase Server application artifacts:


  • Tablespace paths for aggregate storage applications

  • Disk volume paths for block storage applications

Administration Services Release New Features

Changing Essbase Server and Application Log Levels

You can change Essbase log levels at the server and application level in Administration Services Console.

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 Oracle Enterprise Performance Management System. You can also install and configure online Help to run locally. For more information, see the Oracle Enterprise Performance Management System Installation and Configuration Guide.

Cache Sizes Larger than 4 GB

Administration Services supports the enhancement of 64-bit Essbase Server to accommodate larger index, data, and data file cache sizes without setting a scaling factor. The MEMSCALINGFACTOR configuration setting is deprecated. For full database functionality, you must upgrade to the latest client software.

For more information, see the Essbase Readme for this release.

Specifying Multiple Rules Files for Multiple Data Load Files

Previously, it was necessary to specify rules files for each data file prior to a data load, even if all data files used the same rules files. Now, you can select multiple data files and apply the same rules file or files to all of them.

SSL Support for Essbase Connectivity

This release supports the use of Secure Socket Layers (SSL) to connect with Essbase Servers.

No SQL Data Source Option Added to Open SQL Dialog

In the Open SQL Data Source dialog box, you can now select No SQL Data Source for subsequent queries. This enables you to remove SQL information from the rules file.

Auditing Information Added

Additional information (application name, host name) has been added to the information passed between Administration Server and other applications to support SOX auditing requirements.

Aggregate Storage Formulas—MDX Templates

Administration Services includes a set of predefined templates to assist you in creating formulas within aggregate storage outlines. You use these templates in the Member Properties—Formulas tab. Each template opens a form containing input fields for all required information. You select members from the member tree and enter them in the formulas.

Console Activity Logging

Administration Services now provides the option to log all activity within Administration Services Console. In the event you experience problems and need technical assistance, these logs can help diagnose the problem.

Auto-Fix Shared Member Validation Errors

In an outline that does not allow duplicate members, when member information is loaded for a dimension build, the first member with a given name is designated the primary member and subsequent members with the same name are designated shared members. Depending on the order in which data is loaded, it is possible to create a shared member that is higher in the outline than its primary member. However, when the outline is validated, the primary member must occur before any shared members in the outline, or the validation will fail with a verification error.

Administration Services now provides the option to automatically “fix” the outline, converting the first occurrence of a shared member into the primary member, and the former primary member into a shared member. This eliminates the previous validation error on outlines where auto-fix is enabled.

IPv6 Support

Administration Services now supports the IPv6 internet protocol.

Oracle Call Interface (OCI) Support

Administration Services now supports connecting to Oracle databases using the Oracle Call Interface (OCI). You can load data from Oracle databases using Data Prep Editor by specifying an OCI connect identifier.

Increased Length for User, Group, and Filter Names

Essbase and Administration Services support the following limits for user, group, and filter names:

  • Non-Unicode application limit: 256 bytes

  • Unicode-mode application limit: 256 characters

Conversion of Block Storage Outlines to Unicode-mode Aggregate Storage Outlines

Besides supporting the conversion of non-Unicode block storage outlines to non-Unicode aggregate storage outlines, Essbase and Administration Services also support these conversion scenarios:

  • Non-Unicode block storage outline to Unicode aggregate storage outline

  • Unicode block storage outline to Unicode aggregate storage outline

Increased Limit for Alias Tables

Oracle Essbase and Oracle Essbase Administration Services support 32 alias tables for block storage and aggregate storage databases.