Oracle® Essbase Administration Services



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:


New Features

Installation Information

Supported Platforms

Supported Languages

Supported Paths to this Release

Defects Fixed in this Release

Defects Fixed in Release

Known Issues

Documentation Updates

Accessibility Considerations


This document includes important, late-breaking information about this release of Oracle Essbase Administration Services. Review this Readme thoroughly before installing Administration Services.

New Features

See the Oracle Essbase Administration Services New Features. For new features relating to installation, architecture, and deployment changes in this release, see "New Features" in the Oracle Enterprise Performance Management System Installation and Configuration Readme.

Installation Information

Late-breaking information about installation of Oracle Enterprise Performance Management System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration Readme. Review this information thoroughly before installing EPM System products.

Supported Platforms

Information about system requirements and supported platforms for EPM System products is available in a spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on the Oracle Technology Network (OTN:

Supported Languages

Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:

Supported Paths to this Release

You can upgrade to EPM System Release from the following releases:


For instructions to upgrade, see the Oracle Enterprise Performance Management System Installation and Configuration GuideOracle Hyperion Data Relationship Management EPM Architect Integration Guide, "Upgrading EPM System Products."

Table 1. Supported Paths to this Release

Release Upgrade Path FromTo


Note that when moving from Release or to Release, you use the "Apply Maintenance Release" option in Oracle Hyperion Enterprise Performance Management System Installer, instead of following the documented upgrade procedures.

For Oracle Hyperion Financial Close Management, applying the maintenance release is supported only from Release


Note: If you were using Oracle Hyperion EPM Architect Release 9.3.1, you can download the Oracle Hyperion Shared Services release 9.3.3 from My Oracle Support.

A release earlier than Release 9.3.3.x

If you are upgrading from a release earlier than 9.3.3.x, you must first upgrade to a supported release and then upgrade to release For upgrade procedures for the earlier release, see the product installation guides for the interim release that you are upgrading to.

An environment that includes multiple releases, which can include an environment with one instance of Shared Services or an environment with two instances of Shared Services

See "Upgrading from an Environment with Multiple Releases" in the "Upgrading EPM System Products" chapter in the Oracle Enterprise Performance Management System Installation and Configuration Guide.


If you are starting from Release, 9.3.0.x, 9.3.1.x (except for Oracle Essbase,,, and, or 11.1.1.x, Oracle recommends that you upgrade to Release as your interim release. If you are starting from an earlier release, Oracle recommends that you upgrade to the highest level release that directly supports upgrade from your starting release. Security Synchronization between Essbase and Shared Services was removed in Essbase Release 9.3, starting with Release Essbase and Shared Services Release, however, still synchronize security information. For this reason, if you are using Essbase Release,,, or, you must first upgrade all products to Release 9.3.3, instead of Release

Defects Fixed in this Release

If you are coming from Release or, use the Defects Fixed Finder tool to review the list of defects fixed between those releases and Release This tool is available here:

  • 12530474, 13862453 -- When Administration Services is configured using a proxy server, it is possible to create multiple Essbase Server requests with the same action. This problem can be reduced by increasing the timeout setting WLIOTimeoutSecs in the Oracle WebLogic Server configuration file. The default timeout setting has been changed to 3600.

  • 13109460 -- In aggregate storage outlines, the Never Consolidate operator ("^") is not enabled.

  • 13342191 -- Launching Administration Services Console from within a Web browser using HTTPS may fail.

  • 13041473 -- When you are logged into Administration Services as an administrator, opening an outline in Outline Viewer may take longer than opening the same outline in Outline Editor.

  • 13394854 -- When using the Japanese language version of Administration Services Console, setting the alias table to Default in the Define Dynamic Time Series Members dialog box may fail.

  • 9711083 -- In Calculation Script Editor, the functions DATAEXPORT and SET DATAEXPORTOPTIONS are not listed in the alphabetical list of commands and functions.

  • 9707437 -- Using Partition Wizard to open a partition may take an abnormally long period of time.

  • 12697603 -- If you create and save a rules file using an OCI connect string in an environment where no ODBC Data Source Names (DSN) have been defined, when you open this rules file again, the Open SQL Data Source box may not retrieve the saved OCI info and you may not be able to retrieve data.

  • 13250334 -- When restarting a stopped aggregate storage application, the first attempt to open the outline may result in an error message: There is a problem with locking the outline object, error # 1,051,007

  • 13693153 -- Attempting to create a partition on Essbase using an Essbase cluster name may fail.

  • 13587602 -- Using Migration Wizard to migrate applications to Release, filters may not be migrated.

  • 13350620 - Syntax checking for member formulas may not report all syntax errors when comments are not properly closed.

  • 13491431 -- When performing a data load, the dataload.err file is created even when there are no errors with the data load. The file should not be created unless there are errors.

  • 11795960 -- MaxL Editor does not display an auto-complete option for “export outline” when “export” is typed.

  • 13539270 -- In Calculation Script Editor and other editors, the keystroke combination Ctrl+H incorrectly invokes a backspace. The correct behavior would invoke a quick replace dialog box.

  • 1348790, 13592115 -- Performance is slower than expected when viewing outlines or editing objects, such as calc scripts and report scripts.

  • 13425491 -- When Essbase and Administration Services are running in Shared Services mode, the Migration Wizard running in Novice mode fails to migrate LROs from source applications to target applications if, on the Select Objects to Migrate page, you expand the database node. To successfully migrate LROs, do not expand the database node on the Select Objects to Migrate page.

  • 9284745 -- When executing a data load in the background with “Abort on Error” selected, errors encountered during the data load may not result in terminating the process.

  • 9711083 -- When using Calculation Editor, the commands DATAEXPORT and SET DATAEXPORTOPTIONS are not listed under "Functional Commands."

  • 9955008 -- In Administration Services Console, when you attempt to copy a Oracle Hyperion Planning application, the copy does not function properly. You should not be able to copy Planning applications from within Administration Services Console.

Defects Fixed in Release

  • 12814275 -- When migrating Essbase applications to Release, an error message, Failed to migrate the application, may be generated. The application, however, is successfully migrated.

  • 10136151 -- Logging on to Administration Services Console using an offloader may fail and return the following error message, Failed: -1 Your session is not currently authenticated. Please log in.

  • 13078050, 12928265 -- In releases prior to, column headers defined in data load rules files are retained when retrieving from a SQL data source, even when the column names in the SQL data source have been changed.

  • 12396813 -- Under some circumstances, if you close the Administration Services Console window without completing an action, this may cause a subsequent log on attempt to fail. In this case, the error message you receive is, “Failed:-1 your session is not currently authenticated please log in.”

  • 12637958 -- Attempting to export data to a remote server using the MaxL Editor may fail.

  • 10080310 -- When using the MaxL Editor, attempting to save a script using the “Save As” menu option may fail.

  • 12923340 -- When using Calculation Script Editor or Report Script Editor, if you select “View,” then “Navigation,” the Close Window icon (“X”) for the editor may no longer appear.

  • 12545771 -- In the Simplified Chinese version of Administration Services Console, the text in the Assign Access Control dialog box is garbled.

  • 9955008 -- In Administration Services Console, you may incorrectly be given the option to copy Planning applications. If you copy a Oracle Hyperion Planning application from Administration Services, you will be unable to provision the application using Oracle Hyperion Shared Services, and the application will not function properly.

  • 9979257 -- The Financial Reporting file report.gif may be deleted by Administration Server. As a result, in Oracle Hyperion Smart View for Office, opening a Oracle Hyperion Financial Reporting report may result in an error message.

  • 12638860 -- After upgrading to Release, it may not be possible to establish an SSL connection to Administration Server using port 4443.

Known Issues

The following issues are the noteworthy known issues of this release.

  • 14734504 – When Administration Services is deployed using WebLogic Server, the connection to Essbase may be lost and the following error may be displayed: <BEA-280060> <The persistent store "_WLS_EssbaseAdminServices0" encountered a error, and it must be shut down: .store.PersistentStoreFatalException: [Store:280105]The persistent file store "_WLS_EssbaseAdminServices0" cannot open file _WLS_ESSBASEADMINSERVICES0000000.DAT.

    To work around this problem, delete this .DAT file from \user_projects\domains\<base_domain>\servers\<AdminServer>\data\store\default and diagnostics and restart your Java Virtual Machine.

    If this does not resolve the issue:

    1. Log onto WebLogic Server Administration Console, then select Server, then Config Services.

    2. Change :Synchronous Write Policy: to cache-flush.

    3. Select Advanced, then uncheck :Enable File Locking.

    4. Save and activate changes.

    5. Restart WebLogic Server

  • 13336769 -- When running Administration Services on a Linux 32-bit platform with JRockit, opening a data file in Data Prep Editor may cause Administration Server to become unresponsive or to terminate abnormally.

    If this happens, changing your Java Virtual Machine to Sun JRE may resolve the problem.

  • 12771304 -- In Essbase and Administration Services, Data Mining is no longer enabled by default. Documentation regarding Data Mining has been removed from the Essbase and Administration Services documentation set. Data Mining may be completely removed in a future release of Essbase. For Data Mining functionality, please consider Oracle Data Mining, which is an option to the Oracle Database Enterprise Edition.

  • 13359958 -- When logging into an Administration Server configured under Oracle Business Intelligence Enterprise Edition, you must specify the port number with the server name. For information on port settings, see the “Oracle Fusion Middleware Administrator's Guide”.

  • 9791235 -- Searching for members using Outline Editor and the asterisk (*) wildcard may not retrieve the member or members. A similar search using Outline Viewer will succeed.

  • 10101213 -- If you are running Administration Services Console in Windows 2008, you may not be able to create calculation scripts.

  • 8459384 -- In the Simplified Chinese language version of Administration Services Console, log charts for errors and warnings are not displayed in Log Analyzer.

  • 12673530 -- When running Administration Services Console under Windows 7, some functions may not work. If this occurs, changing Windows security so that the Users group has full access to the folder C:\Hyperion\products\Essbase\eas\console\temp (in a default installation) may resolve the issue.

  • 12376259 -- When Oracle WebLogic Server is restarted after stopping Administration Server, Administration Services may not retain information on any Essbase servers added by the user.

  • 13115255 -- If you are attempting to preview data on an Essbase instance that has been specified in Administration Services Console as EssbaseCluster-1, the action may fail with the error message, Can’t connect to olap services. Can’t connect to Essbase server. Error:Essbase Error (1042003): Network Error (11001): Unable to locate [EssbaseCluster-1] in Hosts file.

Documentation Updates

Accessing EPM System Product Documentation

The most recent version of each EPM System product guide is available for downloading or viewing from the EPM System Documentation area of the OTN Web site ( You can also use the EPM System Documentation Portal (, which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.

Deployment-related documentation is also available from the Oracle Software Delivery Cloud Web site (

Individual product guides are available for download on the Oracle Technology Network Web site only.

Copying and Pasting Code Snippets from PDFs

When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid. Workaround: Cut and paste from the HTML version of the document.

Refreshing Database Properties

You must click the Refresh button in the Database Properties window in order to see the latest information. (20333388)

Administration Services Timeout Period

In the topic "Setting the Timeout Period for Administration Services Sessions" in the online help, the timeout period is incorrectly described as twenty-four hours. It should be 45 minutes. The English-language help has been corrected; translated help will still show this as 24 hours.

Log Options Unavailable When Server Disconnected

When an Essbase server is disconnected, options to create, edit, view, and generate Essbase server logs will be greyed out.

Provider Services Required for Data Preview on Clusters

After adding an Oracle Essbase server using a cluster name, Oracle Hyperion Provider Services must be running in order to execute a Data Preview on databases on that server.

Accessibility Considerations

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community.Oracle Essbase Administration Services supports accessibility features, which are described in the product's Accessibility Guide. The most up-to-date version of this guide can be found in the Oracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network (

In addition, this Readme file is accessible in HTML format.