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.

Attention: 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 Metrics.