Oracle® Hyperion Profitability and Cost Management

Readme

Release 11.1.2.4.000


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:

U.S. GOVERNMENT END USERS:

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. Microsoft, Windows, PowerPoint, Word, Excel, Access, Office, Outlook, Visual Studio, Visual Basic, Internet Explorer, Active Directory, and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

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:

Purpose

New Features in This Release

Installation Information

Supported Platforms

Supported Languages

Defects Fixed in This Release

Known Issues

Tips and Troubleshooting

Documentation Updates

Documentation Feedback

Accessibility Considerations

Purpose

This document includes important, late-breaking information about this release of Oracle Hyperion Profitability and Cost Management. Review this Readme thoroughly before installing Oracle Enterprise Performance Management System.

New Features in This Release

See the Oracle Hyperion Profitability and Cost Management New Features. For new features relating to installation, architecture, and deployment changes in this release, see “New Features in this Release” in the Oracle Enterprise Performance Management System Readme.

Use the Cumulative Feature Overview tool to create reports of new features added in prior releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here:

https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1092114.1

Installation Information

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

Note:

Oracle Smart View for Office is no longer installed with the EPM System installer. To download and install the latest release of Smart View, go to http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html.

Supported Platforms

Information about system requirements and supported platforms for EPM System products is available in 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 Oracle Technology Network (OTN):

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Supported Languages

Information about supported languages for EPM System products is available in 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:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Defects Fixed in This Release

This section includes the following defect fixed in Release 11.1.2.4.000:

20086079 – When using Chinese versions of Profitability and Cost Management, not all menus were translated.

This section does not include defects fixed in Release 11.1.2.3.5xx patch sets: To review the list of defects fixed between earlier releases, use the Defects Fixed Finder This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of fixed-defect descriptions with their associated platforms and patch numbers. This tool is available here:

https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1292603.1

Known Issues

The following are the noteworthy known issues of this release.

  • 20361826 – When using Smart View queries with Management Ledger Profitability applications, if the query contains a space in a dimension name, the query fails and an exception message is displayed.

  • 20358800, 20366544 -- Profitability Management Ledger applications do not display properly in Internet Explorer 11 on Solaris systems. For that platform, use Internet Explorer 10 or a supported version of Firefox.

  • 20354742 – Smart View queries in Standard Profitability and Management Ledger applications fail with validation errors when they reference dimension members containing “&” characters in the member name.

  • 20352749 – On Solaris platforms, Standard Profitability and Management Ledger deployments to Essbase can fail when using the APS connection type. If this occurs, use the Embedded connection type (Changing the Connection Type to Embedded Mode).

  • Bug 20351826 - The Management Ledger Profitability sample outline BKSML12 can be saved only to a Unicode application. If saved to an application in non-Unicode format, an error message indicates that a File Save error has occurred.

  • 20293473 – The HPM_EXP_CALC_SCRIPT does not select all rows from HPM_CALC_SCRIPT. It omits rows that were created by the processMultiPOVCalcScript web service API.

  • 20219396 – Reporting cube deployment fails when a generic dimension is associated with a dynamic hierarchy type. An ASO cube cannot have attribute dimensions associated with dynamic generic dimensions. This issue occurs with Standard and Management Ledger application types.

  • 19385648 – An Essbase timeout exception can occur during execution of a Point of View (POV) in parallel mode with multiple threads. Try running in serial mode instead. This problem can also happen in serial mode with larger models (many rules). Oracle recommends grouping rules into smaller rule sets. Then, if you encounter this error, try running the rule sets one at a time, or try running rules individually.

  • 18966716 – For the processCalcOptions web service API, at least one stage must be added to the list of stages to be cleared. If you would prefer to clear no stages, add the last stage to the list, since it typically has no data at the time this operation would be run.

  • 18803075 -- When there are no dimension member aliases defined for any member in any dimension in any application in the entire Profitability and Cost Management instance, Driver Selections/Exceptions and Assignments/Assignment Rule Selections screens are not able to display their data; the screen flickers and then the content disappears. The workaround is to create at least one member alias for at least one dimension in at least one application in the Profitability and Cost Management instance.

Review the following information for best performance.

Dimension Member Naming

It is advised to not use any of the system dimension member names for member names in any of the other dimensions or hierarchies. For example, DirectAllocation or GenealogyAllocation are system members in the AllocationType dimension and these names should not be used in any other dimensions in the model.

ODBC Driver Recommendation

Detailed Profitability applications require a user-configured ODBC data source called PROFITABILITY_DS in order to transfer data into the three Essbase reporting cubes that are now available for Detailed Profitability applications. See “Creating the ODBC Data Source to Enable Data Transfers” in the Oracle Hyperion Profitability and Cost Management Administrator's Guide for more information. Oracle recommends using the DataWire ODBC driver from the Oracle Data Access client for configuring this data source.

Solving Issues with Profitability and Cost Management Connection Type

By default, Profitability and Cost Management uses "Embedded mode" to connect to Essbase. If you are using APS, the APS mode uses many TCP ports while deploying the Essbase cubes. This situation may cause a network error which is displayed in the Profitability and Cost Management log file.

Changing the Connection Type to Embedded Mode

If you receive a network error when using the APS Connection Type, switch the Connection Type to embedded mode, and redeploy the cube.

To set the Connection Type to Embedded mode:

  1. In Profitability and Cost Management, from Task Areas, select Manage Model, and then Model Summary.

  2. On the Model Summary screen, select the Model Level Preference tab.

  3. Under Essbase Connection Information, select embedded from the Connection Type drop-down list.

  4. Click the Save icon.

Setting the JVMOption for Embedded Connection Type

If you are experiencing difficulties using the “embedded” Connection Type mode in Profitability and Cost Management to connect to Oracle Essbase (especially in distributed configurations), you must set the environment variable ESS_ES_HOME as a JVMOption for Oracle Hyperion Profitability and Cost Management to point to any local folder which contains two empty folders called bin and data.

  • If APS is installed on the system, set ESS_ES_HOME to the same value as the APS_HOME environment variable. (APS_HOME should have the required folder structure.)

  • If APS is not installed, set ESS_ES_HOME to any folder which contains empty bin and data folders.

    Note:

    No changes are required if you are using the “APS” Connection Type mode.

To set the JVMOption for the Embedded Connection Type:

  1. Stop the Profitability and Cost Management server.

  2. Edit the Windows registry for HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Profitability0\HyS9HyS9PftWeb.

  3. Add a JVMOptionX (where X is the next integer, based on the existing number of JVMOptions). For example, if the current JVMOptionCount is set to decimal 17, then add JVMOption18.

  4. Set the string value for the new JVMOptionX to -DESS_ES_HOME=<folder-name>, where folder name is the name of the folder that contains the empty bin and data folders.

  5. Increment the JVMOptionCount to the next integer. For example, if JVMOption18 is added, then set JVMOptionCount to decimal 18.

  6. Start the Profitability and Cost Management server.

Setting for High Rate of Network Connections for Windows

To improve the ability of the Windows operating system to deal with a high rate of network connections:

  1. From the Windows Registry, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters.

  2. Add or modify the following registry entries:

    • TcpTimedWaitDelay — Set this to a low value (for example, 30) for the sockets to be released quickly. This DWORD value ranges between 30-300.

    • MaxUserPort — Set this to a high value (for example, 33000) to increase the total number of sockets that can be connected to the port. This is a DWORD value.

    Caution!

    Before modifying these parameters, refer to the Microsoft Windows operating system documentation for more details.

  3. Reboot the system for the changes to take effect.

Increasing Local Port Range for Linux

Caution!

Oracle recommends that only a system administrator who is very familiar with the system should make this change. The system administrator should consider all the effects on the Operating System before making this change.

To improve the ability of the Linux server to deal with a high number of outgoing network connections, increase the local port range:

  1. From a Linux shell, enter the following command to find the current range: Sample Output:

    $ sysctl net.ipv4.ip_local_port_range

    Sample Output:

    net.ipv4.ip_local_port_range = 32768 61000

  2. Set the new local range using one of the following commands:

    • # echo 1024 65535 > /proc/sys/net/ipv4/ip_local_port_range OR

    • $ sudo sysctl -w net.ipv4.ip_local_port_range="1024 64000"

      Note:

      The available parameters are listed under /proc/sys/. This option is only useful for high bandwidth, busy Linux servers or large scale grid servers.

  3. To permanently modify /proc filesystem (the local port range), edit the /etc/sysctl.conf file to append the following:

    # increase system IP port limits

    net.ipv4.ip_local_port_range = 1024 65535

Modifying Default WebLogic Timeout Settings for Lifecycle Management

If you are using Lifecycle Management to import large models, the import may take longer to process than the time specified in the default timeout settings on the Oracle WebLogic Server (defect 7166332). To work around this issue, you must reset the default timeout settings as described in the following procedure.

To modify the default timeout for WebLogic Server:

  1. Navigate to %Middleware_HOME%\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\mod_wl_ohs.conf.

  2. In the configuration file, locate the section LocationMatch/profitability:

    <LocationMatch /profitability>
    SetHandler weblogic-handler
    PathTrim /  
    KeepAliveEnabled ON  
    KeepAliveSecs 20  
    WLIOTimeoutSecs 3000 
    Idempotent OFF 
    WeblogicCluster servername:6756 
    <LocationMatch>
  3. Add the following lines within the LocationMatch/profitability section:

    WLIOTimeoutSecs 3000
    Idempotent OFF
  4. Navigate to:

    %Middleware_HOME%\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\htppd.conf

  5. Set Timeout to 3000, as shown in the following text:

    # Timeout: The number of seconds before receives and sends time out.
    Timeout 3000

    Note:

    The server timeout shown above is a suggested limit, and may be modified to suit the specific timeout settings provided in the documentation for your application server.

Documentation Updates

Accessing EPM System Product Documentation

Find the latest EPM System product guides in the Oracle Help Center (https://docs.oracle.com/en/). To access documents to view or download, click the Applications icon. In the Applications Documentation window, select the EPM tab, and then click the Enterprise Performance Management link.

You can also find deployment-related documentation on the Oracle Technology Network (http://www.oracle.com/technetwork/index.html) and on the Oracle Software Delivery Cloud website (http://edelivery.oracle.com/EPD/WelcomePage/get_form). Or you can visit the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html). There, you’ll find links to My Oracle Support, EPM Supported Platform Matrices, and more.

Online Help in Internet Explorer

Some tables and text may display incorrectly in online help when using Internet Explorer 9.

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.

Documentation Feedback

Send feedback on product documentation to the following email address:

EPMdoc_ww@oracle.com

Follow EPM Information Development on these social media sites:

Accessibility Considerations

Our goal is to make Oracle products, services, and supporting documentation accessible to the disabled community. EPM System products support accessibility features, which are described in the product's Accessibility Guide. Find the most up-to-date version of this guide 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.