Level Options Dialog Box

You can select options to define a level metric, including how the report filter affects the data included in the metric and how metric values are grouped, using the options in the Level Options dialog box. A level metric allows you to specify the level of attribute (referred to as the target) to use when the metric is calculated, regardless of what is contained on any report the metric is placed upon.

The following options are available:

• Relationship with report filter: Determines how the report filter affects the calculation of the metric. The options are:
  • Standard (default): Only data that meets the conditions in the report filter is included in the metric calculation.
  • Absolute: Raises the level of the report filter to the level of the target, if possible, then applies the report filter to the metric calculation. For example, the report filter contains the Washington, DC, Boston, and New York call centers, but the Revenue metric is calculated at the Region level. Because Call Center is a child attribute of Region, the report filter's level is raised to the Region level, and the report filter is treated as if it includes the regions that contain Washington, DC, Boston, and New York (in this case, Mid-Atlantic and Northeast). Data from all call centers in the Mid-Atlantic or Northeast regions are included in the metric calculation, including call centers that are not Washington, DC, Boston, or New York.
  • Ignore: Ignores any conditions in the report filter that are based on the target attribute, as well as any parent or child attributes of the target. For example, if you have a regional revenue metric on a report, any conditions based on Country, Region, or Call Center in the report filter are ignored when calculating the metric. However, a condition based on Year would not be ignored, since Year is not directly related to Region.
  • None: Leaves the metric's relationship with the report filter unspecified. Instead, the target and grouping options define the metric level.
    • If the report includes an attribute in the same hierarchy as the metric's target, the metric is aggregated at the level of the report attribute.
    • If the report does not include other attributes in the same hierarchy as the metric's target, the metric is aggregated as if the Absolute option was selected.
• Metric aggregations: Determines how the metric is grouped, or aggregated, when displayed on a report. The following options are available:
  • Standard (default): Groups data in the metric by the attribute level of the target.

  • None: Excludes the target attribute from being used to group data in the metric. Any children of the target attribute are also excluded. This option is available for metrics calculated at a set level, as opposed to the report level.

  The following options are only used for nonaggregatable metrics. A nonaggregatable metric, such as an inventory metric, is one that should not be aggregated across an attribute. For example, if you have monthly inventory numbers in your data warehouse and want to calculate the yearly inventory, adding the monthly numbers together does not provide a useful business measure. Instead, you may want to use the end-on-hand and beginning-on-hand inventory numbers to see how the total inventory changed during the year.

  • Beginning lookup: Uses the first value in the lookup table.
  • Ending lookup: Uses the last value in the lookup table.
  • Beginning fact: Uses the first value in the fact table.
  • Ending fact: Uses the last value contained in the fact table.

Related Topics

Level metrics for steps to create a level metric

in the Advanced Reporting Help for more in-depth information about level metrics and their elements

Introduction to Metrics for background information about metrics in general