Building relationships between query subjects

You can create a relationship to join logically related objects that your users want to combine in a single report. This is useful for relationships between objects that were not selected during metadata import, were not joined in the data source, or are from multiple sources.
Before you begin
About this task
You can directly create a relationship between the query items. You can also create a complex expression for the relationship. You can also use Framework Manager to automatically generate relationships between objects based on selected criteria. Perform the following steps to create a relationship between two or more subjects:
  1. Ctrl+click one or two dimensions, query subjects, or query items.
  2. From the Actions menu, click Create Relationship. If this relationship is a valid target for a relationship shortcut, Framework Manager asks if you want to create a shortcut to that relationship.
  3. Click OK. The Relationship Definition window opens. You can use this window to modify the relationship.
Example
What to do next

Feedback