MicroStrategy ONE

Metric Editor Formula tab: Level (Dimensionality) advanced options

This dialog box provides the following settings:

  • Allow other users to add extra units to this definition. This setting, which emulates MicroStrategy 6.x behavior, affects only those projects that have been upgraded from 6.x. The option indicates whether the metric accepts dimensionality units, for metrics used at the template level and metrics used in the filter for a metric qualification. This continuation dimensionality is merged with the original units to complete the metric level.

  • Filter setting: uncheck to exclude attributes absent in report or level (dimensionality). This option determines whether the metric filter is applied to the metric calculation. In other words, it specifies whether the definition of the filter is added directly to the WHERE clause of the metric calculation.

    If you clear it, the filter attributes which are not on the report or the level are not included in the Where clause; that is, they are not included in the metric calculation.

By default, both settings are selected. For more information and examples, refer to the Advanced Metrics chapter in the Advanced Reporting Help.

Accessing the Level (Dimensionality) advanced options dialog box

  1. Click Level (Dimensionality) on the Metric component pane (located under the heading "Metric (metric name) is defined as"). The Level (Dimensionality) definition pane displays below the Metric component pane.

  2. Click Advanced.

Related Topics