You use aggregates in cross-database comparisons (CDC) to significantly reduce the comparison volume.
You have defined the data model and the mapping between the data fields of the comparison tables with comparison keys.
You can use aggregates for a comparison between systems where table data fields are not aggregated yet.
You can use aggregates for a comparison between two systems, for example an SAP ERP system with non-aggregated table data fields and an SAP BW system with aggregated data.
First you adjust your data model in the Data Model for Comparison
view.
Define the comparison key as needed for the aggregation level required.
Double-click the table fields for which you want to use an aggregate.
In the Aggregate
field, select the desired aggregate type using the value help. Choose one of the following aggregate types:
COUNT DISTINCT: Count Number of Distinct Values
You use this aggregation if you are interested in the number of different values, which are used in this field, within a range of records defined by an individual comparison key. For example, you compare sales orders between two systems, and you are only interested in the number of different materials used in a specific order.
DISTINCT: Select Distinct Values only
You use this aggregation if you are interested in the distinct values only. For example, you compare data between two systems where the data is not unique in one of the two systems, and you are only interested whether a key like a document number exists in both systems.
MIN: Minimum Value
CDC extracts and compares the lowest value of this field within a range of records defined by a specific comparison key.
MAX: Maximum Value
CDC extracts and compares the largest value of this field within a range of records defined by a specific comparison key.
AVG: Average Value
CDC extracts and compares the arithmetic average of all values for the field, to which the aggregate is applied, within a range of records defined by a specific comparison key.
SUM: Sum of Values
CDC extracts and compares the sum of values for the field, to which the aggregate is applied, within a range of records defined by a specific comparison key.
Choose OK
.
In addition, you can choose Create COUNT GROUP BY
in the context menu of the data model.
As a result, an additional count-field is added to the comparison. You use this aggregation if you are interested in the number of records corresponding to the comparison key only. For example, you compare sales orders between two systems, and you are only interested in the number of line items in an order, and not in the individual line items.
Start the comparison.
Note
The result of a comparison run with aggregated values might not be precisely enough for you to analyze the comparison. For example, if the number of order items deviate, we recommend that you run a detailed comparison to find out which item is missing.