MicroStrategy ONE

Applying report conditions to conditional metrics

When you create a conditional metric, you may want the metric to be calculated so that related elements of the filter specified as the condition for the metric and of the report filter are either ignored or taken into consideration. Related elements are those elements belonging to any attribute having a parent-child relationship with the attribute on which you are placing conditions.

By default, the related elements in the report filter are ignored. The following procedure changes the setting to allow the related elements to apply to the metric. For more information, see Removing related report filter elements.

Prerequisites

To apply report conditions to a conditional metric

  1. Open the metric in the Metric Editor. How?

  2. Click Condition on the Metric component pane (located under the heading "Metric (metric name) is defined as"). The Condition definition pane displays below the Metric Component pane.

  3. Click Advanced. The Condition advanced options dialog box opens.

  4. Clear the Remove related report filter elements check box.

  5. Click OK to return to the Metric Editor.

  6. Click Save and Close to save the metric and close the Metric Editor.