Advanced Options dialog box

The Advanced Options dialog box for a metric qualification or a shortcut-to-a-filter qualification allows you to specify whether existing attribute qualifications should be merged into the calculation of the metric qualification. 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 of the Advanced Reporting Help.

Accessing the Advanced Options dialog box

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