Oracle® Essbase Administration Services

New Features

Release 11.1.2.1


Copyright © 2011, 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 software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS: 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 USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software 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 which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software 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:

New Features for Release 11.1.2.1

New Features for Release 11.1.2

This document describes the new features in Oracle Essbase Administration Services Release 11.1.2 and Release 11.1.2.1. 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.

New Features for Release 11.1.2.1

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.

New Features for Release 11.1.2

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.