MicroStrategy ONE

Metric Editor Formula tab: Level definition

If you select Level (Dimensionality) in the Metric component pane, the Definition pane in the lower part of the dialog box displays a table containing the level for this metric. The level of a metric determines the attribute level of calculation for the metric, such as year or customer. By default, the metric is calculated at the lowest level of any report that it is placed on. This is referred to as the report level.

Keeping the report level allows the metric calculation to adapt to different reports. If the report level is removed, only the level explicitly set on the metric affects the metric calculation, regardless of what the report contains.

Each row of the table in this pane contains the following:

  • Target is the attribute level at which the metric calculation is grouped. It determines the table to use to calculate the metric. Double-click an attribute or a hierarchy in the Object Browser to set the target.

  • Filtering governs the relationship between the report filter and the calculation of the metric. Your options are:

  • Standard filtering to allow the report filter to interact as usual in the metric calculation. The metric calculates only for the elements found in the filter definition. This is the default.

  • Absolute filtering to change the filter on descendents of the target. It raises it to the level of the target, if possible. Absolute filtering influences what is displayed on the report, not its calculations.

  • Ignore filtering to omit filtering criteria based on the attribute in the target and its related attributes (parents and children).

  • None, which can be summarized as unspecified—the filtering behavior for the target is not determined by this component. Instead, the target and group components of this level unit define the filter.

  • Grouping determines how the metric aggregates. Your options are:

  • Standard to group by the attribute level of the target. That is, the metric calculates at the level of the target, if possible.

  • None to exclude the attribute in the target from the GROUP BY clause in the SQL. It also excludes any of the target attribute's children. This option does not appear if the target is set to the report level.

    The remaining options are only used for non-aggregatable metrics. A non-aggregatable metric, such as an inventory metric, is one that should not be aggregated across an attribute.

  • Beginning lookup to use the first value of the lookup table.

  • Ending lookup to use the last value of the lookup table.

  • Beginning fact to access the first value of the fact table.

  • Ending fact to access the last value of the fact table.

A target, grouping, and filtering combination composes one level unit.

The Level definition pane also contains the following buttons:

Related Topics