MicroStrategy ONE

Metric Editor Formula tab: Condition definition

If you select Condition in the Metric component pane, the Definition pane in the lower part of the dialog box displays the conditions for this metric. A metric condition is a metric filter that is independent of the filters on any reports in which the metric is used.

Use this pane to add conditions to the metric. To do this, drag a filter or prompt from the Object Browser into the Condition definition pane, or clickBrowse.

The metric condition must be either a filter or a prompt that returns a list of filters. Only one filter or prompt can be associated with each metric, but that filter can contain multiple qualifications.

The Condition definition pane contains the following buttons:

  • Browse to open the Select a Filter dialog box. You can select a filter from the displayed list or navigate to locate the correct filter or object prompt.

  • Edit to modify the selected filter or prompt. The Filter Editor or Prompt Generation Wizard opens.

  • Clear to remove the selected filter or prompt.

  • Advanced to open the Condition advanced options dialog box, which controls the interaction between the metric condition and the report filter.

Related Topics