Oracle® Hyperion Provider Services

New Features

Release 11.1.2.1.00

Copyright © 2006, 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:

Features Introduced in Release 11.1.2.1

Features Introduced in Release 11.1.2

Features Introduced in Release 11.1.2.1

Logging in to Essbase Using Logical Names

Users can now provide the logical name of an active Oracle Essbase server or cluster to log in. Previously, they were required to provide either the physical name of the Essbase host or the Oracle Hyperion Provider Services URL. To enable use of the logical name, you must configure the new essbase.properties property, aps.resolver.urls to resolve the logical name to the physical name or URL.

Handling of Concurrent Requests

In previous releases, Provider Services did not optimally detect and reject Oracle Hyperion Smart View for Office, Fusion Edition, Java API, or XMLA client concurrent requests in the same session. In this release, when Provider Services is processing a request from a client, it rejects subsequent requests in the same session until it finishes processing the first request.

Optimized HsGetValue Performance

Provider Services has been enhanced to provide significant improvement in the performance of the Smart View function HsGetValue. HsGetValue retrieves data points from the data source to the Smart View worksheet, and in previous versions could be slow, depending on the number of data points to be retrieved.

Optimized Smart View Data Submission

In Oracle Hyperion Smart View for Office, Fusion Edition installations connected to Essbase through Provider Services, the submission of data has been optimized to improve the performance of the Submit Data operation.

Secure Communication between Essbase and Java API

In previous releases, communication between Provider Services Java API and Essbase was not secure. In this release, you can choose to specify secure communication between Java API and Essbase using Secure Socket Layer (SSL).

Allocations and Custom Calculation API

The new Allocations and Custom Calculation API enables users to execute custom calculations on aggregate storage cubes.

Features Introduced in Release 11.1.2

Increased Limit for Alias Tables

Provider Services supports 32 alias tables for block storage and aggregate storage databases.

Multiple Language Code Support for Alias Tables

Using the Essbase API, you can specify multiple language codes for an alias table. When you create an alias table, a language code is not specified. You can get the set of language codes and clear the language codes associated with an alias table. When clearing aliases from an alias table, language codes are removed from the alias table. When copying an alias table, language codes are removed from the copied alias table. When renaming an alias table, language codes are preserved in the renamed alias table.

IPv6 Support

Provider Services supports the IPv6 internet protocol.

Client Locale

In this release, when users of Provider Services client products move from one client to another or from one instance to another instance of the same client, the language of the original client is retained, including UI, error messages, and alias tables. For example, if you are logged into a client with Japanese as the preferred language, then Japanese will remain the language of client you change to. Previously, the language reverted to English when you changed clients.

Java APIs

New Java APIs are included in Provider Services to provide the following functionality:

  • MaxL execution from JAPI

  • Re-registering Oracle Essbase applications with Oracle's Hyperion® Shared Services

  • Ability to get and set DateFormat on the cube outline

  • Identifying whether an outline is enabled for varying attributes

  • Ability to create a Unicode ASO application

  • Asynchronous JAPI for dataload and dimbuild

  • Support for recursive hierarchies

  • Drill-through on a range of cells in Studio-deployed Essbase cubes

  • Batch reading of arrays

  • Ability to get Oracle Hyperion Provider Services cluster status so that applications and cubes can be enabled or disabled automatically

EPM System New Features

  • Most Oracle Hyperion Enterprise Performance Management System products have adopted Oracle Diagnostic Logging (ODL) as the logging mechanism. The ODL framework provides uniform support for managing log files, including log file rotation, maximum log file size, and the maximum log directory size. For more information, see the “Using EPM System Logs” chapter of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.

  • Oracle Configuration Manager (OCM) integrates with My Oracle Support and provides configuration information for Oracle software. It assists in the troubleshooting, maintenance, and diagnostics of your EPM System deployment. For more information about Oracle Configuration Manager see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

  • With this release, many EPM System products support hostnames that resolve to IPv6 addresses. See the Oracle Hyperion Enterprise Performance Management System Certification Matrix. IPv4 support (both hostname and IP address) remains unchanged from earlier releases.

  • Oracle Hyperion Enterprise Performance Management System supports the following types of SSL configurations:

    • Full SSL Deployment (including data access)

    • SSL Terminating at the Web Server

    • SSL Accelerators (Off-loading)

    • Two-way SSL

      For more information on the SSL configurations, see the Oracle Hyperion Enterprise Performance Management System Security Administration Guide.