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

Accessing an Essbase Server

In Database Connection Manager, the Server field allows various ways to access the Oracle 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.