Oracle® Hyperion Provider 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:

Provider Services Release New Features

Provider Services Release New Features

Provider Services Release New Features

Provider Services Release 11.1.2 New Features

This document describes the new features in Oracle Hyperion Provider Services Releases 11.1.2,,, and For more information about these features, see the Oracle Hyperion Provider Services Administration Guide.

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

Provider Services Release New Features

Detection of Essbase Data Sources From Registry

To assist Oracle Hyperion Smart View for Office connection management, Provider Services dynamically detects and retrieves Essbase data sources using the registry.

Provider Services Release New Features

Essbase Web Services

Web services are self-contained, modular applications that one can describe, publish, locate, and invoke over a network. Web services allow access to regular applications using a Web browser. Web services use XML to code and decode data, and SOAP (Simple Object Access Protocol) to transport it.

Essbase Web Services will expose Essbase user and administrative functionality in a services-oriented (SOA) environment via Provider Services, and allow Essbase to be easily integrated with both Oracle and third-party applications.

Logging in to Essbase Using Logical Names

Users can now provide the logical name of an active Essbase server or cluster to log in. Previously, they were required to provide either the physical name of the Essbase host or the Provider Services URL. To enable use of the logical name, you must configure the new 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 Smart View, 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 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.

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 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 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 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.