MicroStrategy ONE

Set Qualification pane: Metric qualification

All filters contain at least one qualification; a metric qualification is one type of set qualification. A metric qualification creates a set of attributes based on the metrics associated with those attributes. For more information, see Metric set qualifications.

Set Qualification pane: Metric qualification content

Different options are displayed in the Set Qualification pane depending on the selected Set Qualification Type. When the Type is set to Metric, the following options are displayed:

  • Prompt: Opens the Prompt Generation Wizard to create a prompted metric qualification, which allows a user to select a function, select an operator, or specify the value for a metric at report run time.

    After you create the prompt, the Set Qualification pane displays the prompt information; you can only edit the prompt and set the advanced options. Edit the prompt by clicking the Edit Prompt button which replaced the Prompt button. See the Advanced option below for a description of the advanced options.

  • Output Level: The level at which to calculate the set. Click ... (the browse button) to open the Level: Output tab (metric qualification filter), which allows you to set the output level.

    If you do not set the output level, the metric's dimensionality is used. However, the set is calculated at the report level if:

    • The metric is a compound metric

    • The metric's dimensionality is set to report level

    • The metric's dimensionality is set to nothing

  • Metric: The target metric, that is, the metric to test in the qualification. Use any of the following methods to select a metric:

    • Drag the metric from the Object Browser.

    • Type the name of the metric.

    • Click ... (the browse button) to browse for the metric.

    • Click Choose a metric prompt to open the Prompt Generation Wizard, which allows you to qualify on a metric. See Prompted metric qualifications for more information.

  • Function: The criterion for metric calculation. Select from Metric Value, Rank, and Percent.

  • Operator: The operator to determine a value range for the metric calculation. Select from the drop-down list; the options vary depending on the Function selected.

  • Drop-down list and text box: The drop-down list contains the types of operator value to which to compare. These types are listed below, with information on how to fill in the text box next to the drop-down list.

  • Value: Enter the value to qualify the metric on in the text box.

  • Simple Prompt: Creates a value prompt, allowing you to select a single value on which to qualify. The Prompt Generation Wizard opens. See Prompted metric qualifications for more information.

    This is the same as clicking the Simple Prompt icon at the end of the text box. If this icon is not displayed, you can display it by selecting the Show all available prompts buttons option in the My Preferences dialog box. See Defining default options for the Filter Editor for instructions.

  • Metric: Creates a metric-to-metric qualification. Type a metric name in the text box or click ... (the browse button) to browse for a metric.

  • Custom: Enter a custom expression to qualify the function in the text box.

    If you selected Between or Not Between as the Operator, two lists and two text boxes are displayed.

  • Break By: (Displayed if Function is set to Rank or Percent) Accesses the Level: Breakby tab to set the attribute level at which to restart counting the values for the metric.

  • Advanced: Accesses the Advanced Options dialog box, which allows you to specify whether existing attribute qualifications are merged into the calculation of the metric qualification. By default, the qualifications are merged.

Accessing Set Qualification pane: Metric qualification

  1. Do one of the following:

    • In the Filter Editor, select Add a Set qualification in the Filtering Options pane.

    • In the Custom Group Editor, select Add a Set qualification from the Custom Group Options window.

    • The Set Qualification pane opens.

  2. Select Metric from the Type drop-down list.

Related Topics