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.
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:
- Ctrl+click one or two dimensions, query subjects, or query items.
- 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.
- Click OK. The Relationship Definition window opens.
You can use this window to modify the relationship.