The General options are described below:
Dynamic Aggregation function: Select the function used for dynamic aggregation, which is the rollup of metric values that occurs when an attribute is moved from the report grid to the Report Objects.
Dynamic aggregation allows you to change the level of report aggregation on-the-fly, while you are reviewing the report results. This feature allows metric values to be aggregated at different levels depending on the attributes included on the report without having to re-execute the report against the data warehouse. Dynamic aggregation occurs when the attributes included on the report layout changes. The attributes included on the report layout changes when you move an attribute or attribute form off of the report layout to the Report Objects pane, or when you move an attribute or attribute form from the Report Objects pane back onto the report layout. As what is included on the report layout changes, metric values are dynamically aggregated to the new level of the report.
Allow smart metric: Available for a compound metric. Select whether the metric uses smart subtotals or not.
The formula of a compound metric is based on arithmetic operators and non-group functions. A compound metric, at a high level, can be composed of multiple objects joined by arithmetic operators, such as Metric1/Metric2 or (Fact1 + Fact2)/Fact3. The subtotal of a compound metric can be calculated in different ways:
Calculate the sum of all parts of the compound metric, then calculate the compound metric. This formula is represented by Sum(Metric1)/Sum(Metric2).
Calculate the compound metric for each row of the report, and then roll up the data to the correct level. This formula is represented by Sum(Metric1/Metric2).
The first case uses smart subtotals, which calculate subtotals on the individual elements of a metric (also referred to as a smart metric). For example, the Avg Ticket metric is calculated as the Net Sales metric divided by the Trans Count metric. The Avg Ticket metric can be totaled as follows:
Add all the net sales values together. Add all the trans count values together. Divide the two sums. This is a smart metric.
Divide each net sales value by each trans count value. Sum up these ratios.
Prerequisites
This procedure assumes that you have created a metric. For steps, see Creating a metric.
To access the Advanced Metric Options: General dialog box:
If the metric is not already open, click the metric to edit it. Either the Function Editor or Formula Editor opens, depending on the type of metric.
Click the Options button. This displays the Advanced Metric Options dialog box.
In the list of categories on the left, click General.
Related topics
About metrics for background information about metrics in general
Creating a metric for steps to create a metric
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices