|
Siebel Order Management Infrastructure Guide > Product Selection and Pricing 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. See Table 12 for further description. Arguments
Table 12. Aggregate Method Arguments
|
|
Context |
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 (for example: Price List ID, Product ID, Qty). For the Count aggregate type, the output row contains the Group By fields plus a field named 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 (for 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. (For example: Price List ID, Product ID). |
Example
Figure 22 shows an example of arguments for a PSP procedure step named Sum Product Quantity, which calls the Aggregate method.
Figure 22. Example of Arguments for Aggregate Method
|
|
