Transformable AggMetric

The Transformable AggMetric VLDB property allows you to define what metrics should be used to perform transformations on compound metrics that use nested aggregation.

For example, you create two metrics. The first metric, referred to as Metric1, uses an expression of Sum(Fact) {~+, Attribute+}, where Fact is a fact in your project and Attribute is an attribute in your project used to define the level of Metric1. The second metric, referred to as Metric2, uses an expression of Avg(Metric1){~+}. Since both metrics use aggregation functions, Metric2 uses nested aggregation.

Including Metric2 on a report can return incorrect results for the following scenario:

• A transformation shortcut metric is defined on Metric2.
• Metric1 is defined at a lower level than the report level.

In this scenario, the transformation is applied to the outer metric, which in this case is Metric2. To perform the transformation correctly, the transformation should be applied for the inner metric, which in this case is Metric1. To apply the transformation to Metric1 in this scenario, you can use the Transformable AggMetric VLDB property. The options are:

• False (default): The metric uses default transformation behavior. This option should be used for all metrics except for those metrics that are defined for a scenario similar to Metric2 described above.
• True: The metric is defined as a metric to use to perform a transformation when it is included in another metric through nested aggregation. This option should be used only for metrics that are defined for a scenario similar to Metric2 described above.

Levels at Which You Can Set Tthis

Metric only