MicroStrategy ONE
Set Qualification pane: Relationship qualification
You can use a relationship filter to define a specific type of relationship between two or more attributes that are not directly related, such as Year and Region. You can create a relationship qualification by selecting Add a Set Qualification, from the Filtering Options dialog box, and then choosing Relationship from the Set Qualification Type drop-down list.
All filters contain at least one qualification; a relationship qualification is one type of set qualification. A relationship qualification creates a set of attributes based on the relationships between those attributes. For more information, see Relationship set qualifications.
Set Qualification pane: Relationship qualification content
Different options are displayed in the Set Qualification pane depending on the Set Qualification Type. When the Type is set to Relationship, the following options are displayed:
-
Output Level: The level at which to calculate the set. Click ... (the browse button) to open the Level: Output tab, which allows you to choose the set of attributes to relate.
-
Filter Qualification: The relationship to qualify on. You can drag a filter from the Object Browser to the Filter Qualification box. The following buttons are also provided:
-
Browse to select an existing filter.
-
Create to access the Qualification Editor to create a filter on the fly within this qualification.
Once a filter has been selected or created, this button is replaced by Modify, which opens the filter in the Qualification Editor so that you can edit the filter.
-
Clear deletes the selected filter.
-
Relate By: The logical table that relates the attributes in Output Level with the filter. The options are:
-
Use System Default to use the schema to select the appropriate table.
-
Browse to select a logical table or fact.
-
Advanced: Accesses the Advanced Options dialog box, which allows you to specify whether the filter criteria is applied to the entire report or the relationship qualification itself. By default, it is applied to the entire report. For more information, see Applying qualifications independently of relationship filters.
Accessing Set Qualification pane: Relationship qualification
-
In the Filter Editor, select Add a Set qualification in the Filtering Options pane. The Set Qualification pane opens.
-
Select Relationship from the Type drop-down list.