1. User's Guide
  2. Managing Database Connections
  3. Accessing an Essbase Server

Accessing an Essbase Server

Access and Oracle Essbase serer from within the Database Connection Manager.

To access an Essbase server:

  1. From Oracle Hyperion Enterprise Performance Management Workspace with the BI Catalog open, select Tools, and then Database Connection Manager.
  2. Select an Essbase database connection, and then click New or Edit to access the Database Connection Properties dialog box.

In the Database Connection Properties dialog box, the Server field allows various ways to access the Essbase server. Access can be in one of two modes: embedded mode or 3 Tier APS mode. For the 3 Tier APS mode, Oracle Hyperion Financial Reporting defines the APS server machine name in the JConsole using the EssbaseJAPIServer property. All API calls are sent through that server.

  • In both modes, you specify the Essbase server directly - Host[:port]. For example, EssServer1:1423.

  • With an Essbase cluster name, for both modes, you can either:

    • Specify the Essbase cluster name directly. For example, EssCluster1. Financial Reporting internally resolves the cluster name to the server name at runtime.

    • Enter the APS URL with an Essbase cluster name. For example: http://host:port/aps/Essbase?ClusterName=EssCluster1. where host:port is the APS server to resolve the Essbase cluster name. Failover is supported across the Essbase servers in the Essbase cluster.

  • In 3 Tier mode only, you can enter the APS cluster name. For example, APSCluster1.

    The APS cluster name and members are defined in the Essbase Admin Utility. This method supports failover and load balancing across the Essbase servers in the APS cluster.