Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-EI-APD (Application Component) Analysis Process Designer⤷
RSAN_WB (Package) APD - Tool - User Interface
Basic Data
| Data Element | RSAN_WB_DST_GROUP_BY |
| Short Description | Transformation "Aggregation" |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | STRG | Character String of Variable Length |
| Length | 0 | |
| Decimal Places | 0 | |
| Output Length | 0 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Text |
| Medium | 20 | Description |
| Long | 40 | Description |
| Heading | 60 | Description |
Documentation
Use
This node enables you to group data according to the values of specific fields (grouping fields; database function Group-by) and to aggregate in other fields the data within these groups (aggregation fields). You can also use this node just to group data, which you do by selecting just grouping fields and no aggregation fields.
The node can be integrated at any point in the analysis process.
Activities
- From the available fields, select at least one grouping field and, if required, one or several aggregation fields.
- If necessary, change the sort sequence of the grouping fields from ascending to descending.
- Specify the appropriate aggregation behavior for the aggregation fields. You can currently choose from the following values:
- SUM: All values of a group (that is, all grouping fields have identical values) are added together and the total is forwarded to the subsequent node.
- MIN: Only the minimum value from the group is forwarded.
- MAX: Only the maximum value from the group is forwarded.
- AVG: The average of all values of a group is forwarded.
- AV0: The average of all values of a group is forwarded. With this sort of aggregation, zero values in the fields are not considered.
- NOP: No aggregation
Depending on the type of aggregation field, not all executed aggregation behaviors are supported. For example, in the case of a field of the type characteristic, only the values MIN and MAX produce useful results.
Runtime behavior
Since the data is to be sorted, all data must first be read. Once it has been sorted successfully, the data is aggregated and forwarded in groups to the subsequent nodes. Only those fields that were either aggregated or used as grouping fields are forwarded.
Example
If the characteristics material (0MATERIAL), material group (0MATL_GROUP), and customer (0CUSTOMER) are available as input fields for the node as well as the key figures costs (0COSTS) and revenue (0REVENUE) but you are only transferring customer and product group as grouping fields and the key figures as aggregation fields, then the data records are summarized as follows:
Input data:
Customer Material Material Group Revenue Costs
1000 1000 A 12 4
1000 1002 B 14 6
1001 1000 A 32 12
1001 1001 A 44 20
1001 1003 B 23 10
Aggregation at the level customer / material group with aggregation SUM for both key figures:
Customer Material Group Revenue Costs
1000 A 12 4
1000 B 14 6
1001 A 76 32
1001 B 23 10
Aggregation at the customer level with aggregation SUM for revenue and AVG for costs:
Customer Revenue Costs
1000 26 5
1001 99 14
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30B |
