MicroStrategy ONE

Joining view filter qualifications with operators

When a view filter has multiple qualifications at the same output level, they are always joined by logical operators. When qualifications are joined, operators govern the interaction between different filtering conditions. Whenever you have more than one qualification in a view filter at the same output level, you can define the operator as any of the following:

By default, multiple qualifications are joined with AND, but you can change the logical operator, as described in To change the logical operator below. You cannot change the logical operator between two metric qualifications if all of the following are true:

  • The metric qualifications use two different metrics (for example, Revenue in Qualification 1 and Profit in Qualification 2).

  • The metric qualifications are not metric-to-metric qualifications, but instead compare the metrics to numeric values.

  • The metric qualifications are evaluated at the grid level.

Because the output level of view filter qualifications determines which qualifications can be joined with logical operators, by default all attribute qualifications are at the same output level as other attribute qualifications, and all metric qualifications are at the same output level as other metric qualifications. This mean that an attribute qualification can be joined with other attribute qualifications, and metric qualifications can be joined with other metric qualifications, but attribute and metric qualifications cannot be joined.

However, you can modify the output level of metric qualifications. If you modify a metric qualification to be evaluated at the report level, the metric qualification can be joined with attribute qualifications and with any other metric qualifications that have been defined to be evaluated at the report level. Metric qualifications evaluated at the report level cannot be joined with metric qualifications evaluated at the grid level. For information on the benefits of evaluating metric qualifications at the report level versus the grid level, see Evaluating qualifications at the report or grid level.

To change the logical operator of a view filter

This procedure assumes that you have already added multiple qualifications to the view filter. For instructions, see Creating a view filter.

  1. In MicroStrategy Developer, log in to a project.

  2. Run the report in Grid View.

  3. If the View Filter area is not displayed, from the View menu, select View Filter.

  4. In the View Filter area, right-click the operator, point to Toggle Operator, and then choose the new operator.

  5. Save the report.

Related Topics