Bug 412604 - IES 4.3 BIRT TCT#4
Summary: IES 4.3 BIRT TCT#4
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 4.3.0   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-Data-inbox@eclipse.org CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-09 12:26 EDT by Matthew Talbot CLA
Modified: 2013-07-16 15:04 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew Talbot CLA 2013-07-09 12:26:19 EDT
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!
Comment 1 Lin Zhu CLA 2013-07-16 15:04:13 EDT
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)