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.

Database connections must be of the same type; for example, both must be Oracle Essbase database connections or both must be Oracle Hyperion Financial Management database connections Multiple data sources in one grid that are of different types (Financial Management, Oracle Hyperion Planning, Essbase) are not supported. To retrieve data from a different database type, add a second grid to the report. The second grid retrieves data from a different database type connection. In the first grid, reference the data from the second grid with formulas. Use text functions to display the correct member names for the formulas and hide the display of the second grid in the report.

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.