1. Using Oracle Essbase
  2. Access Multiple Essbase Servers From Smart View

C Access Multiple Essbase Servers From Smart View

When you have multiple independently deployed Essbase instances, you can set up access to all available Essbase Server nodes in the Smart View connection panel using a single sign-on to one centralized Smart View URL.

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 is https://myhost.example.com:9001/essbase/smartview. The Nodes are Financial (with applications ASOSamp and Sample nested underneath), Planning (with application Sample nested underneath), and ROcluster (with application Sample underneath, expanded to show database Basic).

  • The centralized Smart View URL is https://myhost.example.com:9001/essbase/smartview.

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

  • The node named ROcluster 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.