Connections to Essbase Clusters

Essbase clients and servers can connect to an Essbase cluster by way of a URL in this format:

http(s)://host:port/aps/Essbase?ClusterName=clusterName.

You can also connect to an Essbase cluster using only the cluster name, but you must first enable this by modifying a configuration file to specify the Provider Services server that resolves the cluster name in the URL. The Provider Services server is specified in these configuration files:

To connect to a Provider Services Essbase cluster using Financial Reporting or Web Analysis, you must configure Financial Reporting or Web Analysis for three -tier mode.

To configure Financial Reporting for three-tier mode:

  1. Start MIDDLEWARE_HOME/EPMSystem11R1/products/financialreporting/bin/FRConfig.cmd.

  2. Specify the EssbaseJAPIServer as the Provider Services server.

  3. Restart Financial Reporting, and enter the Provider Services cluster name as the Server Name.

To configure Web Analysis for three-tier mode:

  1. Log on to EPM Workspace as an admin user.

  2. Select Navigate, then Administer, then Reporting and Analysis, and then Web Applications.

  3. Right-click WebAnalysis Web-Application, and select Properties.

  4. On the Essbase Configuration tab, set these properties and then click OK:

    • EESEmbeddedMode=false (The default setting is true.)

    • EESServerName=Provider Services server name (The default setting is localhost.)

    • Click OK, and restart theWeb Analysis server for changes to take effect.