Data Aggregation

Data Aggregation is the gathering and expressing of data in a summary form. When Data Aggregation is launched, data from the reference tables or temporary data tables are normalized into a set of Data Mediation event tables.

Aggregation processes one event at a time. Normalization or initial aggregation is customized using a SQL query and is specified in the Data Mediation profile. Data stored in Data Mediation event tables represents complete usage event data. All data from Data Mediation event tables is aggregated and the results are loaded into the set of metric-based result tables. These metric requests are processed for the Accounting Component rating engine. Budgeting information and billing transactions are created based on the resulting data contained within the metric result tables.

Imported usage data by defined profiles is processed for Accounting Component through Data Aggregation. The usage data is imported using the Metric Data Profile. Before usage data is aggregated, the data must be normalized into a common format. The common format consists of fields known as Server Mandatory fields. There are five Default Server Mandatory Fields which are required in every record to qualify as complete event usage data.

Accounting Component creates billing transactions based on the event results. The data imported through Data Mediation is aggregated by fiscal period. The data can be aggregated for a defined fiscal period or for all fiscal periods. Aggregation produces results by server mandatory fields, for example, by account, service offering, metric, and fiscal period.