MicroStrategy ONE

Advanced Options dialog box

You can specify whether existing attribute qualifications should be merged into the calculation of the metric qualification, by using the Advanced Options dialog box. By default, this option is selected and it combines the qualifications.

A metric qualification is contained in a separate pass of SQL, creating a temporary table or "mini-report." If the qualifications are merged, attribute qualifications are added to that pass of SQL. If they are not merged, the attribute qualifications are not included in the metric qualification. Instead, they appear in the main SQL pass. For an example, see the Advanced Filters chapter in the Advanced Reporting Help.

Accessing the Advanced Options dialog box

  1. Click Advanced on the Set Qualification pane: Metric qualification or Custom Group Editor: Shortcut to a Filter pane in the Custom Group Editor.