Community
Participate
Working Groups
File: eclipse\plugins\org.eclipse.birt.data\org\eclipse\birt\data\engine\i18n\Messages.properties Context: data.olap.InvalidNestAggregationOn=Fail to calculate nest aggregation "{0}" due to its aggregation on levels do not exist in its based aggregation(s) Question: Can you please elaborate a bit on what this string is trying to convey? Thank you for your time!
In BIRT xTab, the aggregation can target other aggregations. Say, we have aggregation on Country, Year, Month level, aggr1 = SUM(sale, Country, Year, Month). We can then define a nested aggregation on Country level to calculate the overall sales by Country: aggr2 = SUM(aggr1, Country). To define such a nested aggregation, there are a couple of rules need to be followed. One of rule is that the target level of the nested aggregation must be included in the target level of the aggregations that it is refer to. i.e., the following aggregations are valid: aggr2' = SUM( aggr1, Year) But the following is invalid because it refers to an aggregation on level that does not exists in the aggregation it is based on. aggr2'' = SUM( aggr1, ProductLine)