Adding an Essbase Server for Reporting Applications

To add an Oracle Essbase server on which reporting application databases reside, on the Add Essbase Server dialog box:

  1. In Essbase Server, type the server name.

    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 User Name, type your user name.
  3. In Password, type your password.

    Your name and password are stored so you do not retype them in future sessions.

  4. Optional: To test the connection to the Essbase server, click Validate Connection.
  5. Click OK.