MicroStrategy ONE

Set Qualification pane: Relationship qualification

You can use a relationship qualification to define a specific type of relationship between two or more attributes that are not directly related. For example, relationship filtering allows you to create a custom group element that displays all the stores selling Nike shoes in the Washington, DC area, or all customers who have checking accounts but not saving accounts.

Create a relationship qualification by selecting Add a Set Qualification, from the Custom Group Options pane, and then choosing Relationship from the Set Qualification Type drop-down list.

A relationship qualification is a type of set qualification; a custom group contains at least one qualification. A relationship set qualification creates a set of attributes based on the relationships between those attributes. For more information, see Creating custom group relationship 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 ... to choose the set of attributes to use, on the Level: Output tab.

  • 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 create a filter on-the-fly using the Qualification Editor.

    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 it.

  • 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: Specifies whether the filter criteria is applied to the entire report or the relationship qualification itself, using the Advanced Options dialog box. 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

  1. Open the Custom Group Editor. (How?)

  2. Select Add a Set qualification in the Custom Group Options pane. The Set Qualification pane opens.

  3. Select Relationship from the Type drop-down list.

Related Topic