You can populate a grid with data from multiple database connections. After you define a grid’s initial database connection and dimension layout, you can change the database connection for one or more rows or columns of the grid. You can define another database connection for each data row or data column.
You can preserve the members selected in the grid when changing database connections on a grid row or column. You must map all dimensions that are assigned to rows or columns in a grid from the current database connection to the new database connection. Dimensions on the point of view (POV) need not to be mapped.
To assign multiple database connections to a grid:
In a grid, select one or more data rows or columns for which you want to change the database connection.
In the Row or Column Properties sheet, click the Select Database Connection button,
.In the Select a Database Connection dialog box, select a database connection from the Database Connection drop-down list, then click OK.
If you want to create another database connection, select the New Database Connection button. For information on adding another database connection, see Managing the Explore Repository.
In the Map Dimensions Between... dialog box, map dimensions between the default database connection and the selected database connection. You do this by selecting a dimension from the pull-down list in the right column for each dimension in the left column.
Optional: Select an alias table for the new database connection.