Creating an Essbase Server Connection

The first time you deploy a cube to an instance of Essbase Server, you are prompted for Essbase connection information.

  To create a connection to Essbase Server:

  1. In the Metadata Navigator, select the Essbase model from which you want to deploy a cube.

  2. Right-click the model name and select Cube Deployment Wizard.

    The Essbase Login dialog box is displayed, where you will create a reusable connection to Essbase.

    Note:

    If there is already an existing Essbase connection, the Cube Deployment Wizard is displayed, not the Essbase Login dialog box.

  3. In Essbase Login, provide the following information, and then click Login:

    • A Name for this connection

    • An optional Description.

    • The Server name where the Essbase instance or cluster resides, and the Port number.

      The default for Server and Port is the Essbase instance or cluster running on the same machine as Essbase Studio.

      Note:

      Cluster names are case sensitive. The default cluster name is EssbaseCluster-1.

    • The name of the User and the Password needed to access this Essbase Server.

    • A Data Encryption method:

      • No Encryption—Thhe default mode for communication between Essbase Studio Server and an Essbase Server instance or cluster.

      • SSL—If the Essbase Server instance or cluster to which you are connecting is configured for Secure Socket Layer (SSL) protocol over TCP/IP, select this method.

        SSL enables secure communication between Essbase Studio Server and Essbase.

        Note:

        If the Essbase Server is not configured to support SSL, then a connection cannot be established and an error message is displayed.

    • If you are connecting to an Essbase Server cluster, select Cluster.

      Note:

      Essbase Server clusters must be set up prior to creating an Essbase connection. See Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide and Oracle Hyperion Enterprise Performance Management System High Availability Guide for information on setting up clusters.

    The connection name you provide is selectable now and during future deployments in the Essbase Server Connection field of the Cube Deployment Wizard.