Aggregation Calculation

The aggregation calculations process aggregates source data that correspond to the Aggregation Measuring Component’s dimensions. The queries used for this process are based on data source template SQL extended by the value identifiers defined on the measuring component type of the Aggregation Measuring Components being processed.

The aggregation calculation process is initiated by Aggregation by MC Set Monitor batch process (D1-AMCS), and is performed by monitor algorithms defined on the Active state of the Aggregation Measuring Component business object. The algorithms used by each type of Aggregation Measuring Component are as follows:

Aggregation Measuring Component Business Object Aggregation Algorithm
Dynamic Aggregator - Billed Quantities (D1-AggBilledServiceQuantities) Aggregate Billed Service Quantities (D1_​AGGBSQ)
Dynamic Aggregator - Composite (D1-AggregatorComposite) Aggregate Interval Measurements (D1_​AGGINT)
Dynamic Aggregator - Customer Quantities (D1-AggregatorCustomerQuantity) Aggregate Customer Specific Quantities (D1_​AGGCSQ)
Dynamic Aggregator - Interval (D1-AggregatorInterval) Aggregate Interval Measurements (D1_​AGGINT)
Dynamic Aggregator - Items (D1-AggregatorItems) Aggregate Item Data (D1_​AGGITEM)
Dynamic Aggregator - Scalar (D1-AggregatorScalar) Aggregate Scalar (D1_​AGGSCLR)

See Types of Aggregation for more information about aggregation calculations for each type.

Other Calculations

In addition to basic aggregation processing, other calculations can be performed on aggregated measurements as needed. For instance, a common step in aggregating date for use in market settlements is applying a loss factor to aggregated data to reflect system losses (line loss, etc.) between generation-level quantities and end consumption quantities.

These types of calculations can be performed by value derivation algorithms. These are algorithms based on the Derive Aggregated Quantity Using a Formula (D1-DERAGGQTY) algorithm type which apply a configured formula to aggregated measurement values. For instance, to apply a loss factor, an algorithm can retrieve effective-dated factor values for a loss factor and multiply each aggregated measurement value by the appropriate factor value.

The Execute Aggregation Value Derivation (D1-EAGGVALD) algorithm on Aggregation Measuring Components executes any value derivation algorithms specified for Value Identifiers on the Aggregation Measuring Component Type.