Use the Joins tab to select join usage preferences.
Use All Joined Topics—Use all joined (non-iconized) topics in the data model.
Use The Minimum Number Of Topics—Use only of topics represented by items on the Request Line.
Use All Referenced Topics—Use only of topics represented by items on the Request or Limit lines. Changing join usage usually changes the number of rows retrieved from the database. It also introduces the possibility that novice users may create improperly joined queries.
Use Defined Join Paths—Use user predefined join path that groups the joins necessary to query from the data model. Click Configure to create a custom join path.
Note that since most data models do not have the same predefined join paths, you cannot save the Use Defined Join Paths option as a default user preference. (For more information on default user preferences, see Saving Data Model Options as User Preferences.)
Use Automatic Join Path Generation—Instructs Interactive Reporting to dynamically generate joins based on the context of user selections on the Request and Filter lines.