Issue:: You cannot connect to an Essbase cluster using a cluster name; for example, by entering MAXL> login admin password EssbaseCluster-1.
Solution: Take one of these actions:
Ensure that the URL you are using follows one of these formats:
http(s)://host:port/aps/Essbase?ClusterName=cluster
http(s)://host:port/aps/Essbase?ClusterName=cluster&SecureMode=<yes|no> (to connect to Essbase over a secure protocol)
To connect to an Essbase cluster using only the cluster name, modify 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:
For server-to-server communication–essbase.cfg
Use this format:
ApsResolver http(s)://host:port/aps
You can specify several Provider Services servers in essbase.cfg, using a semicolon (:) between server names.
For client-to-server communication–essbase.properties
Use this format:
ApsResolver=http(s)://host:port/aps
Note: | The ApsResolver setting must be in essbase.cfg on the client side for tools or applications that use Essbase CAPI (such as MAXL, Esscmd, and Planning). The ApsResolver setting must be in .essbase.properties on the client side for tools or applications that use Essbase JAPI (such as Oracle Hyperion Provider Services and Essbase Studio). |