Registry Optimizations

Setting the JVMOption for Embedded Connection Type

If you are experiencing difficulties using the "embedded" Connection Type mode in Oracle Hyperion 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 in order for 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 a 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.