Assigning Multiple Database Connections to a Grid

Retrieve data from different database connections and define the database connection for each data row or data column.

You can preserve the members selected in the grid for the database connection on a grid row or column. You must map all dimensions that are assigned to rows or columns in a grid. Dimensions on the point of view (POV) need not to be mapped.

To assign multiple database connections to a grid:

1. In a grid, select one or more data rows or columns for which you want to change the database connection.
2. In Row Properties or Column Properties, click the Database Connection button .
3. In the Database Connection Properties dialog box, select an existing data source from the drop-down list or click New Connection to create a new database connection, and then click OK.

   To create another database connection of the same type, select another data row or column, then click again.

4. In the Map Dimensions Between dialog box, map dimensions between the default database connection and the selected database connection.

   To map dimensions, for each dimension in the left column, select a dimension from the drop-down list in the right column.

5. Optional: Select an alias table for the new database connection.
6. Click OK.