Defining Relational Drill-through

Upon accessing the Modify Relational Drill-through Connection dialog box, you complete these tasks in the creation of relational drill-through navigation:

  1. Define a JDBC RDBMS connection, using the Configure JDBC Driver dialog box.

  2. Test the connection.

  3. Indicate the relational database table name.

  4. Update the Columns list.

  5. Map relational columns to dimensions in the OLAP database.

  6. Indicate whether to pass filter dimensions or page dimensions and a row limit (if ).

  7. Click Apply.

For instructions for creating relational drill-through navigation, See Creating Relational Drill-Through.