Add Semi-Additive Metrics
In AtScale, creating a Semi-Additive metric allows you to choose dimensions over which the fact data should not be aggregated. Instead, you have the choice of returning the first or last non-empty value of a result set.
info
Semi-Additive Metrics and Calculated Metrics that depend on Semi-Additive metrics cannot be used in User-Defined Aggregates (UDAs). However, AtScale System-Defined Aggregates are able to use Semi-Additive metrics and their dependent Calculated metrics in aggregates.
Creating semi-additive metrics
To create a semi-additive metric, you must either define it via SML entirely, or create the metric using the Edit Metric pane, then edit its SML.
To create a semi-additive metric:
- Create a metric as described in Add Addive or Non-Additive Metrics.
- In the Aggregation type field for the metric, select one of the following options: Average, Sum, Min, Max.
- Save the metric, then switch to the Text Editor tab.
- Define the
semi_additive
property for the metric, then save the file. For more information, see the AtScale SML Object Documentation on GitHub.