Specifying an Automatic Join Strategy

You can instruct Interactive Reporting Studio to use one of three different strategies when automatically joining topics. The strategy chosen is employed with a particular connection and saved with the Interactive Reporting database connection file.

  To select an automatic join strategy for a database connection:

  1. If you are not currently connected to the database, select an Interactive Reporting database connection file and log on.

  2. Select Tools, then Connections, and then Modify.

    The Meta Connection Wizard is displayed with the On The Current Connection option selected.

    Note:

    For information on metatopics and metadata, see Creating Metatopics.

  3. Click Next.

    The Meta Connection Wizard displays the repository where the meta settings are stored.

  4. Click Edit.

    The Metadata Definition dialog box is displayed.

  5. Select the Joins tab.

  6. Select a join strategy. Join strategy options are:

    • Best Guess—Joins topics through two items that share the same name and data type

    • Custom—Joins topics according to specified schema coded in SQL in the Metadata Join Definitions area

    • Server-Defined—Joins topics based on primary and foreign keys established in the underlying relational database

  7. When you have completed the selection, click OK.