Oracle® Essbase Analytics Link for Hyperion Financial Management

Readme

Release 11.1.2.2


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

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

Purpose

New Features

Installation Information

Supported Platforms

Supported Essbase Server Platforms

Supported Languages

Supported Paths to this Release

Defects Fixed in this Release

Known Issues

Tips and Troubleshooting

Documentation Updates

Accessibility Considerations

Purpose

This document includes important, late-breaking information about this release of Oracle Essbase Analytics Link for Hyperion Financial Management. Review this Readme thoroughly before installing Analytics Link.

New Features

Analytics Link release 11.1.2.2.000 supports Oracle Enterprise Performance Management System 11.1.2.2.000 only. Other EPM System releases are not supported.

This release of Analytics Link supports only Oracle Hyperion Financial Management applications that include four Custom dimensions.

Installation Information

Analytics Link is installed using Oracle Universal Installer 11.2 (32-bit), regardless of whether you are installing Analytics Link on a 32-bit or 64-bit platform. OUI 11.2 (32-bit) installs a version of Analytics Link that matches the bitness of the operating system.

Supported Platforms

Analytics Link is supported on these platforms:

  • Microsoft Windows (32-bit and 64-bit)

  • Red Hat Enterprise Linux Release 5.3 (64-bit), only when Analytics Link Server is deployed on Oracle WebLogic Server (64-bit)

Supported Essbase Server Platforms

  • Microsoft Windows (32-bit and 64-bit)

  • Linux (32-bit and 64-bit)

Supported Languages

Analytics Link is available only in English.

Supported Paths to this Release

Analytics Link 11.1.2.2.000 requires a fresh installation.

Bridges that were created in a previous release of Analytics Link must be redefined in Release 11.1.2.2.000.

Defects Fixed in this Release

  • 13770020 -- When deleting an Oracle Essbase outline, security filters are not deleted from the Essbase application.

  • 13741644 -- Extracting Financial Management data or metadata to Microsoft SQL Server fails when the extracted table columns names contain the following special characters or spaces:

    • & — ampersand

    • ; — semi-colon

    • * — asterisk

    • ! — exclamation point

    • @ — at sign

    • + — plus sign

    • ( — open quote

    • ) — close quote

Known Issues

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

  • 12756649 -- Analytics Link does not support connecting to a named instance of Microsoft SQL Server 2008, as the Financial Management repository or Analytics Link Data Store.

  • 13697301 -- When Analytics Link Server runs as a Windows service, the following message is returned:

    java.lang.NoClassDefFoundError Exception [HR#10196]: com/hyperion/css/CSSException
  • 13893080 -- Creation of anEssbase transparent partition target database fails when the TARGETASOOPT configuration setting in the essbase.cfg file is set to TRUE.

    Workaround: At the end of the essbase.cfg file, add the following setting:

    TARGETASOOPT EAL_application_name FALSE

    Then restart Essbase Server for the essbase.cfg change to take effect.

  • 12595391 -- When the Entity dimension uses the Dimension Mapping transformation type, Analytics Link Data Synchronization Server encounters an error while extracting data to an RDBMS bridge target. The following error message is written to the dss.log file:

    HR#13538: error in open calling SQLNumResultCols ([Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'EALEntity_ParentId'. [state=S0022 code=207])
  • 14046334 -- Migration of group-based Financial Management application security is not supported. This behavior is a limitation of Analytics Link. See Migration of Group-Based Financial Management Application Security Is Not Supported.

Tips and Troubleshooting

  • The following functionality in Financial Management is not visible in Analytics Link:

    • UserDefinedX attribute

    • Account CustomXTopMember attribute

    • Scale currency attribute

    • Parent entity ownership

    • Active and inactive status of entities

    • Cell text (CellText)

    • Calculation status (CalcStatus)

  • When running long consolidations, Essbase might see numbers that represent work-in-progress data. To avoid this situation, in Analytics Link, use Real-Time mode (instead of On-Demand mode) by turning off automatic synchronization until long consolidations are completed.

  • Analytics Link does not support:

    • Attribute dimensions in an Essbase target database

    • Some features of EPM System 11.1.2.2 products (such as localization)

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 (http://www.oracle.com/technology/documentation/epm.html). You can also use the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html), 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 (http://edelivery.oracle.com/EPD/WelcomePage/get_form).

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.

Analytics Link Installation and Administrator's Guides

The Analytics Link installation and administrator's guides have not been updated for Release 11.1.2.2.000. Use these guides:

  • Oracle Essbase Analytics Link for Hyperion Financial Management Installation Guide for 11.1.1.4.002

  • Oracle Essbase Analytics Link for Hyperion Financial Management Administration Guide for 11.1.1.4.002

Migration of Group-Based Financial Management Application Security Is Not Supported

Analytics Link does not support the migration of Financial Management application security when Oracle Hyperion Shared Services groups are configured for access to only a subset of the dimensions in the application (instead of access to all of the dimensions in the application).

For example, the following Oracle Hyperion Shared Services groups are configured for access to a specific Financial Management application dimension:

  • ENT_US_ADMIN”—This group security class definition allows users in the group to access the application security classes for the ENTITY dimension only.

  • ENT_EUR_PROMOTE”—This group security class definition also allows users in the group to access the application security classes for the ENTITY dimension only.

  • SCENARIO_ACTUAL_ADMIN”—This group security class definition allows users in the group to access the application security classes for the SCENARIO dimension only.

  • SCENARIO_BUDGET_METADATA”—This group security class definition also allows users in the group to access the application security classes for the SCENARIO dimension only.

In this example, a user that needs administrator access to Actual data of US entities would be included in the “ENT_US_ADMIN” and “SCENARIO_ACTUAL_ADMIN” groups.

In migrating group-based Financial Management application security to Essbase, the security filters that Analytics Link creates in the Oracle Essbase database does not correctly reflect the Oracle Hyperion Financial Management application security configuration.

Accessibility Considerations

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. Oracle Essbase Analytics Link for Hyperion Financial Management documentation supports accessibility features. The most up-to-date versions of the Oracle Essbase Analytics Link for Hyperion Financial Management Installation Guide and Oracle Essbase Analytics Link for Hyperion Financial Management Administration Guide can be found in the Oracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network (http://www.oracle.com/technology/documentation/epm.html).

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