Using Defined Join Paths

Defined Join Paths are customized join preferences that enables you to include or exclude appropriate tables based on the items referenced on the Request and Limit lines. “Bridge tables,” which are not explicitly referenced in the query, are transparently added to the SQL From clause. The net effect limits the query to all referenced tables based on available table groupings, which generate the most efficient SQL for queries off the data model.

To use defined join paths:

Select DataModel, then Data Model Options.
The Data Model Options dialog box is displayed.
Select the Joins tab to display the Joins tab.
Select the Use Defined Join Paths option and click Configure.
The Define Join Paths dialog box is displayed.
In the Define Join Paths dialog box, click New Join Path to name and add a join path.
The New Join Path dialog box is displayed.
In the New Join Path dialog box, enter a descriptive name for the join path and click OK.
The join path name is highlighted in the Defined Join Paths dialog box.
Select a topic in the Available topics list and use the move right (-->) button to move it to the Topics In Join Path list.
To remove join paths from the Topics in Join Path list, select the move left (<--) button, to remove join paths from the Topics In Join Path list.

When join paths are completely defined for the data model, click OK.

Tip:	Join paths are not additive; Interactive Reporting Studio cannot determine which tables are common among several paths and link them on that basis. Join paths are not linear, and if selected, the simplest join between all tables in the path is included when processing a query.