MicroStrategy ONE

Applying qualifications independently of relationship filters in custom groups

You can specify whether the filter criteria for the relationship qualification is applied to the report as a whole. The full name of this option is Also apply this qualification independently of the relationship filter, and it is located on the Advanced Options dialog box. By default, this property is selected, which applies the criteria to the whole report.

If the option is cleared, the filter criteria is applied to the relationship qualification itself and not to the entire report. In other words, the filter is only included in the SQL statement that resolves the relationship filter (subquery) and not the outer query that resolves the report as a whole.

For instructions on creating a relationship set qualification, see Creating custom group relationship qualifications.

Relationship qualifications in custom groups are the same as relationship qualifications in filters.

For more information and examples, see Applying qualifications independently of relationship filters and the Advanced Filters chapter of the Advanced Reporting Help.

Prerequisite

This procedure assumes you have already created a relationship qualification. For instructions, see Creating custom group relationship qualifications.

To apply qualifications independently of relationship filters

  1. If the qualification is not already open, double-click the qualification in the Custom Group Definition pane of the Custom Group Editor. (How to open the Custom Group Editor)

  2. Click Advanced. The Advanced Options dialog box opens.

  3. Clear the Also apply this qualification independently of the relationship filter check box.

  4. Click OK to return to the Set Qualification pane.

  5. Click OK to close the Set Qualification pane.

  6. Save the custom group. How?

Related Topic