Defining relationships between query subjects

To join logically-related query subjects that your users want to combine in a single report, you create a relationship between the query subjects.

This is useful when objects were not selected during metadata import, were not joined in the data source, or are from multiple data sources.

Procedure

  1. In Project Explorer, double-click the query subject for which you want to define a relationship.
  2. In the query subject editor, click the Relationships tab.
  3. Click the New Relationship icon.
  4. In the Add Relationships dialog, select the query subject that you would like to join with the query subject selected in step 1, and click OK.
  5. Click the Edit button for the query subject that you added.
    The relationship editor is displayed.
  6. In the relationship editor, click the Add button to add a new row of query items. Then, click the query item in the query subject on one side, and select the matching query item in the query subject on the opposite side. Repeat this action for all query items that you want to match.
  7. Specify the cardinality between the matching query items, as documented in the Cardinality topic.
  8. Click a different object in Project Explorer to exit the relationship editor.