Application management : Tools : Data Aggregation : Configuring Data aggregation properties : Aggregation properties BO for ReportSX and CalculateSX : Aggregation of fields
Aggregation of fields
The data level can have a hierarchical structure. With the following keys you can define to add the values of child records to their parent. The summary is processed bottom up, from deepest to root level. So the values of grand children are added to their parent, all the values of the parents are added to the grandparents and so on.
Key
Value example / Info
Extension
SUM.DECIMAL
SUM.DECIMAL=Free­Decimal1,Free­Decimal10, Free­Decimal11
Info
• Aggregation of fields. Specify DECIMAL fields.
• The aggregation is performed for all the listed fields in the value part.
• These fields need not necessarily be populated by this SX.
• If you do not want to execute aggregate, the value should be empty.
ReportSX
SUM.DECIMAL.OVERWRITE
SUM.DECIMAL.OVERWRITE=Free­Decimal1,Free­Decimal10, Free­Decimal11
Info
Same as for SUM.DECIMAL, but the value of the parent record is not taken into account. Its value is the sum of all child values.
Example
Value child 1 is 10, value child 2 is 11, value of the parent is 12. After aggregation, the value will be 33 if the OVERWRITE property is not specified or 21 if it is specified.
ReportSX
SUM.INTEGER
SUM.INTEGER=­FreeInteger8,­FreeInteger10
Info
• Aggregation of fields. Specify INTEGER fields.
• The aggregation is performed for all the listed fields in the value part.
• These fields need not necessarily be populated by this SX.
• If you do not want to execute aggregate, the value should be empty.
ReportSX
SUM.INTEGER.OVERWRITE
SUM.INTEGER.OVERWRITE=Free­Decimal1,Free­Decimal10, Free­Decimal11
Info
Same as for SUM.INTEGER, but the value of the parent record is not taken into account. Its value is the sum of all child values.
ReportSX