Group Level (Magic xpa 4.x)
The Group logic unit creates breaks during the data view processing.
The Group level is only relevant for Batch task types, and can be located anywhere in a task.
You can use the Group logic unit to calculate sums at certain levels, to display data by groups, or to print breaks in a report.
You define a Group logic unit for a variable. The Group logic unit is executed when the variable value changes. For example, you can have a Group level for Customer Identification or Number of Purchases. When you change the variable for the Group level, you must reset the Prefix and Suffix.
You can define several Group logic units for different variables in the same task.
The order of the Group logic units should match the order of the segments in the task's sort criteria. The higher segment in the index should be the higher Group logic unit. For example, if the task's Main Source index segments are Country_Code and then City_Code, the Group logic unit should be defined in the same order; first the Group logic unit for the Country_Code variable and then the Group logic unit for the City_Code variable.
Grouping data according to part of the segments in the sort criteria is allowed, as long as the segments are used from top to bottom. Grouping data starting from the middle of the sort criteria segments may give an undesirable result.
In the Group Prefix, place the operations that the engine executes after the break parameter value has changed. That is, at the beginning of the group of records with a new value in the break parameter. This level is typically used to print report group headers. There is no limit to the number of Group levels that can be defined.
In the Group Suffix, place the operations that the engine executes before processing the record with a break parameter value that has changed. The Group Suffix section also stores the operations that are used for the printing of report group footers.
|
|
The Group Suffix should follow the Group Prefix. You should not open a new Group logic unit between them.
|
How Magic xpa Executes Group Levels
Batch Task Event Handling
Group Level Example
