Connecting to a Stand-alone Essbase Server

You can manage Oracle BI EE and Essbase connections through Smart View. For Essbase only, to connect Provider Services through Administration Services, use the following procedure.

Through Administration Services Console, Provider Services can connect to stand-alone Essbase Servers or Essbase Server clusters. Smart View, Java API, and XMLA users connect to Essbase Servers through Provider Services. To users, the accessed database is transparent. From their perspective, they connect to, and retrieve data from, one data source.

Note:

To enable users to select any stand-alone Essbase Server, add the stand-alone server to Provider Services through Administration Services Console. Add Essbase Server to the User Properties window in Administration Services Console before adding the stand-alone server to Provider Services.

  To connect to a stand-alone Essbase Server:

  1. From Enterprise View or a custom view, select the Essbase Servers node to add Essbase Servers to administer.

  2. Right-click and select Add Essbase Server.

  3. In Add Analytic Server, enter the Essbase Server name, user name, and password, confirm the password, and click OK.

  4. Repeat step 2 to add additional Essbase Servers.

  5. From Enterprise View or a custom view, under the Hyperion Provider Services node, select a provider.

  6. Right-click and select Create, then Create Stand-alone Server.

  7. In Add Stand-alone Server, from the list of servers added in step 3, select a server.

  8. Click OK.

    The name of the stand-alone Essbase Server is displayed under the Stand-alone Server node.

    Note:

    Alternatively, if you have existing stand-alone servers, you can select the Stand-alone Server node under a provider's name, right-click, and select Create Stand-alone Server.