Bookshelf Home | Contents | Index | PDF     

Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Physical Layer in an Oracle BI Repository > Setting Up Connection Pools >

Setting Up Connection Pool Properties for Multidimensional Data Sources

When you import an external multidimensional data source, the connection pool is automatically set up in the physical layer. You can add a connection pool manually using the instructions in this section.

Table 8 describes some general properties that are shared among connection pools with different data sources. Table 9 describes the properties in this dialog box that are unique to multidimensional data sources.

To set up connection pools for a multidimensional data source

  1. In the Physical layer of the Administration Tool, right-click a database and select New Object > Connection Pool, or double-click an existing connection pool.

    The following is an illustration of the General tab for a multidimensional data source in the Connection Pool dialog box.

    Click for full size image
  2. In the Connection Pool dialog box, in the General tab, complete the fields using information in Table 8 and Table 9.

    NOTE:  Table 9 describes the connection pool properties or descriptions that are unique to multidimensional data sources.

Table 9. Multidimensional Data Source Connection Pool General Properties
Property
Description

Data Source Information:

Catalog

The list of catalogs available, if you imported data from your data source. The cube tables correspond to the catalog you use in the connection pool.

Data Source Information:

Data Source

The vendor-specific information used to connect to the multidimensional data source. Consult your multidimensional data source administrator for setup instructions because specifications may change. For example, if you use v1.0 of the XML for Analysis SDK then the value should be Provider-MSOLAP;Data Source-local. If using v1.1, then it should be Local Analysis Server.

Shared logon

Select the Shared logon check box if you want all users whose queries use the connection pool to access the underlying database using the same user name and password.

If this option is selected, then all connections to the database that use the connection pool will use the user name and password specified in the connection pool, even if the user has specified a database user name and password in the DSN (or in the user configuration).

If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the user profile.

URL

The URL to connect to the XMLA provider. It points to the XMLA virtual directory of the machine hosting the cube. This virtual directory needs to be associated with msxisapi.dll (part of the Microsoft XML for Analysis SDK installation). For example, the URL might look like the following:

http://SDCDL360i101/xmla/msxisap.dll

Use session

Controls whether queries go through a common session. Consult your multidimensional data source administrator to determine whether this option should be enabled. Default is Off (not checked).

  
Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.