Show TOC

Function documentationUsing Aggregates

 

You use aggregates in cross-database comparisons (CDC) to significantly reduce the comparison volume.

Prerequisites

You have defined the data model and the mapping between the data fields of the comparison tables with comparison keys.

Features

Comparing Tables with Single Item Data

You can use aggregates for a comparison between systems where table data fields are not aggregated yet.

Comparing Tables with Single Item Data and Aggregated Data

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.

Activities

First you adjust your data model in the Data Model for Comparison view.

  1. Define the comparison key as needed for the aggregation level required.

  2. Double-click the table fields for which you want to use an aggregate.

  3. 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.

  4. Choose OK.

  5. 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.

  6. Start the comparison.

Note 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.

End of the note.