Editing an Essbase Server for Reporting Applications

You can use the Edit Essbase Server dialog box to change logon credentials and connectivity details such as server name and port numbers. For the default Oracle Essbase server, you can make updates in the Manage Data Source dialog box for the application’s associated data source.

Note:

If you use the EPM System Configurator to change the Essbase server, you must update the server name within Oracle Hyperion Planning.

Tip:

Using the Planning Upgrade Wizard, you can update Essbase server information for multiple reporting applications (see Updating References to Reporting Essbase Servers).

To edit an Essbase server displayed for reporting application databases, on the Edit Essbase Server dialog box:

  1. In Essbase Server, select the server from the list of available servers.

    To configure a data source to support Essbase failover in active-passive clustering mode, replace the Essbase Server name value with the APS URL followed by the Essbase cluster name; for example, if the APS URL is http://hostname:13090/aps and the Essbase cluster name is EssbaseCluster-1, then the value in the Essbase Server name field would be:

    http://hostname:13090/aps/Essbase?clusterName=EssbaseCluster-1

    Entering the Essbase cluster name without the APS URL in the Essbase Server name field is not supported in this release.

  2. In Server Name, type the server name.
  3. In User Name, type your user name.
  4. In Password, type your password.
  5. Optional: To test the connection to the Essbase server, click Validate Connection.
  6. Click OK.