1. Using Oracle Essbase
  2. Centralized Smart View URL, and Read-Only Clusters

C Centralized Smart View URL, and Read-Only Clusters

You can set up access to multiple Essbase Server nodes from the Smart View connection panel using one centralized URL. To provide high-availability and load balancing for cubes that are heavily used for query and reporting, you can create active-active (read-only) clusters of identical Essbase cubes.

Note:

This feature is available only for independent deployments.

By default, only a single Essbase server node, usually named EssbaseCluster, is accessible from Smart View. To enable centralized URL access to more than one server node, you must perform some configuration steps.

In the following Smart View image,


Multiple Essbase server nodes accessible under a centralized Smart View URL. The URL for this private connection is https://iad150.example.com:9001/essbase/smartview. The Nodes are represented by aliases PHX250 and LocalMachine. A read only cluster is represented as ROcluster (with application Sample underneath, expanded to show database Basic).

  • The centralized Smart View URL for this private connection is https://iad150.example.com:9001/essbase/smartview.

  • Two Essbase servers, with aliases PHX250 and LocalMachine, are running on separate instances that an administrator configured to be accessible under a centralized Smart View URL.

  • The node named Sample-Readonly is an active-active (read-only) cluster. A read-only cluster is not required for centralized Smart View URL access, but is an option available if you want to set up a cube that offers high availability without writeback.

To enable single URL access to multiple Essbase instances from Smart View, select a workflow, depending on your deployment type.

The workflows are mutually exclusive. If Essbase is configured with EPM Shared Services, only Essbase instances that are registered with EPM will be displayed in the centralized Smart View URL.