Hierarchical Method

The Hierarchical method processes a hierarchy of input rows from start to end or end to start. For example, it could be used for a customizable product price roll-up.

Arguments

Input Argument	Description
Context	Optional. Property set of variables shared across all rows.
Row Set	The set of rows to process.
Output Row Set	Optional. The property set used for output.
Process Condition	A Boolean condition that is evaluated to determine whether to process each row.
Row Id Field	The ID field in {Row} (example: “Id”).
Parent Field	The name of the parent ID field that defines the hierarchy in the input row set.
Direction	Up or Down. Indicates the direction of traversal of the tree.
On Top Row [1..20]	Actions to perform on the first row in each tree.
On Row [1..20]	Actions to perform on every row.
On Parent Row [1..20]	Actions to perform on every row that has children beneath it in a tree.
On Leaf Row [1..20]	Actions to perform on rows that have no children.

Example

The following figure shows an example of arguments for a PSP procedure step named Customizable Product Roll-Up, which uses the Hierarchical method.