Assigning Multiple Database Connections Grids

You can retrieve data from a 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.

Note:

Database connections must be of the same type (for example, both must be Essbase database connections or both must be Financial Management database connections) Multiple data sources in one grid that are of different types (Financal Management, 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 of the same type to a grid:

  1. Open a report.

  2. In a grid, select one or more data rows or columns for which you want to change the database connection.

  3. In the Row or Column Properties sheet, click the Select Database Connection button, Lookup icon.

  4. In the Select a Database Connection dialog box, select a database connection from the Database Connection drop-down list, then click OK.

    Note:

    If you want to create another database connection of the same type, select another data row or column, then click Database Connection button again.

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

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

  7. Click OK.