Providing Connection Information for Cube 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 continue with 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. 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 more information on using the ODBC settings in conjunction with the server.essbase.streamingCubeBuilding property, see Deploying Date Measures.

   • 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.

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

   See Essbase Properties..

7. 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.