Providing Connection Information for Cube Deployment

Use the “Essbase Server connection options” page of the Cube Deployment Wizard to specify Essbase and data source connection information. You can also modify Essbase model properties before deployment.

  To set up server, data source, and model properties information for cube deployment:

  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 Server connection options page is launched.

  3. In Essbase Server Connection, select the connection representing the Essbase Server to which you want to deploy.

    To deploy to an Essbase Server connection that is not on the list, click New Connection and complete the steps in Creating an Essbase Server Connection, then proceed to step 4.

  4. Enter the Application and Database name to which you are deploying.

    Note:

    If you are deploying from an Essbase model that is enabled for XOLAP, Oracle strongly recommends that you use a new application and database name, or use the Delete all members first option to deploy over an existing XOLAP application.

  5. Optional: Select the Enable streaming mode for cube deployment check box to perform this cube deployment in streaming mode.

    Note:

    The Enable streaming mode for cube deployment check box setting is not retained across deployments. To use the check box for streaming mode, it must be set each time you perform a cube deployment.

    Streaming mode means that during cube deployment, Essbase Studio Server queries the external data source directly (rather than querying the external data source using an ODBC connection).

    The Enable streaming mode for cube deployment check box is enabled when the Essbase model being deployed contains single or multiple relational data sources.

    The check box is disabled when the data sources used in the Essbase model are one or more text file sources, one or more Dimension Server (Performance Management Architect) sources, or a mix of text file and relational sources.

    If Essbase Studio Server is running in nonstreaming mode (the server.essbase.streamingCubeBuilding property is set to false), selecting this option will override that setting.

  6. In the Data source setting group, select an option:

    • ODBC (Essbase dynamically creates ODBC connection string)—Use the data source name dynamically created by Essbase. This is the default.

    • ODBC (Enter ODBC DSN name)—Enter the ODBC DSN name to use.

      If you choose to deploy using an ODBN DSN name in order to take advantage of your own custom ODBC DSN parameter settings, follow these guidelines:

      • Set up your ODBC DSN before beginning deployment, on the server machine where Essbase is installed.

      • The ODBC DSN must have the same user name and password as the data source connection being used in this deployment.

      Note:

      For additional information on using the ODBC settings in conjunction with the server.essbase.streamingCubeBuilding property, see Deployment Scenarios and Streaming Cube Building Property Considerations.

    • OCI (Enter OCI connect identifier)—Enter the Oracle OCI connect identifier to use.

      The syntax for an Oracle OCI connect identifier is:

      host:port/SID

      Following is an example OCI connect identifier where the host server name is “myserver,” the port number is 1521, and the Oracle SID (Service Identifier) is “orcl”:

      myserver:1521/orcl

      Note:

      Other connect identifier formats can be used. Refer to Oracle documentation for more information on OCI.

    By calling an ODBC DSN or OCI connect identifier, you can take advantage of the particular parameters that you have set in the DSN or in OCI. For example, during cube deployment, you may use an Oracle Wire Protocol driver that is set up to take advantage of driver performance and failover options.

    All items in the Data Source Settings group are disabled under the following conditions:

    • The Enable streaming mode for cube deployment check box is selected (step 5).

    • Essbase Studio Server is running in streaming mode (the server.essbase.streamingCubeBuilding property is set to true).

    • The Essbase model contains elements from multiple data sources

    • The Essbase model was created using a text file data source

    • The Essbase model was created using a Dimension Server (Performance Management Architect) data source

  7. Optional: Click Model Properties if you want to modify the Essbase properties of the model.

    See Essbase Properties..

  8. Click Next to launch the Cube deployment options page of the wizard.

    Note:

    If errors exist in the model, you are warned when you click Next. A dialog is displayed asking if you want to launch the Essbase Model Properties dialog box. Click “Yes” to launch the properties dialog box and correct the errors.