Siebel Order Management Infrastructure Guide > PSP Engine > Row Set Transformation Toolkit Methods >

Aggregate Method

The Aggregate method calculates the sum, average, minimum, maximum, or count of subgroups of the input row set.

Input Argument


Optional. Property set of variables shared across all rows.

Row Set

The set of rows to process.

Output Row Set

Output Row Set is always created and contains the aggregation results. Each row contains the Group By fields plus the Aggregate Fields (example: Price List ID, Product ID, Qty). For the Count aggregate type, the output row contains the Group By fields plus a field called Count.

Process Condition

A Boolean condition that is evaluated to determine whether to process each row.

Aggregate Type

Sum, Avg, Min, Max, or Count.

Aggregate Field

The field to aggregate (example: Qty). Required for all types except Count. Multiple fields can be aggregated by specifying a comma-separated list of field names.

Group By

Optional. A comma-separated list of row field names. Defines the groups of aggregates. (Example: Price List ID, Product ID).


Figure 21 shows an example of arguments for a PSP procedure step named Sum Product Quantity, which calls the Aggregate method.

Figure 21. Example of Arguments for Aggregate Method

Siebel Order Management Infrastructure Guide Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.