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.