1. Order Management Infrastructure Guide
  2. Implementing Aggregate Functions

Implementing Aggregate Functions

The arguments for the Hierarchical Look-Up method are used with the aggregate functions shown in the following table. See the following table for further description.

Aggregate Function Approach

Closest

On First Match condition, set the output row value to a match record value.

Minimum

On Match condition, set the output row value to the value of an expression:

{Row.Value} = IIF({Match.Value} < {Row.Value}, 
{Match.Value}, {Row.Value})

Maximum

On Match condition, set the output row value to the value of an expression:

{Row.Value} = IIF({Match.Value} > {Row.Value}, 
{Match.Value}, {Row.Value})

Accumulated

On Match condition, set the output row value to the value of an expression:

{Row.Value} = {Row.Value} + {Match.Value}
Note: This can be adjusted to support compounding adjustments.

Example

The following figure shows an example of arguments for a PSP procedure step named Hierarchical Contract Adjustment, which uses the Hierarchical Look-Up method.

Example of Arguments for Hierarchical Look-Up Method. This image shows the following Input Arguments (Input Argument, Value): BC Id Field, Business Component, Business Object, ... , On First Match 1, ... , On Match 4, Row Id Field, Row Set, and so on.