Community
Participate
Working Groups
Created attachment 184971 [details] Report that uses a datacube, crosstab and 2 bar charts When using a datacube with a 'count' summary field as a data source for a chart produces the incorrect results. The attached report illustrates the problem. You will see a CrossTab which displays the values correctly for both a sum and a count summary field. The chart that uses a sum field works correctly, but the chart that uses the count field does not.
The cause of this bug is the default aggregation of measure binding on report item is not true, it should be set as SUM rather than COUNT. Because the COUNT aggregation for measure binding on report item has no more sense, so in BIRT, there is a special convertion to use SUM instead of COUNT. Now fixed this in chart UI, when user select cube set, just doing above rule to add measure bindings on report item. Please remove old chart from report and insert a new chart to verify this bug.
(In reply to comment #1) > The cause of this bug is the default aggregation of measure binding on report > item is not true, it should be set as SUM rather than COUNT. Because the COUNT > aggregation for measure binding on report item has no more sense, so in BIRT, > there is a special convertion to use SUM instead of COUNT. > Now fixed this in chart UI, when user select cube set, just doing above rule to > add measure bindings on report item. > Please remove old chart from report and insert a new chart to verify this bug. This bug is there no matter what chart type you pick... You can not change the aggregation method on the Series 1 definition. It is greyed out, that is the point of the bug. I have also verified this bug is present in Actuate BIRT Designer Professional 11. This bug is not resolved in my opinion, unless I am missing something.
(In reply to comment #2) > (In reply to comment #1) > > The cause of this bug is the default aggregation of measure binding on report > > item is not true, it should be set as SUM rather than COUNT. Because the COUNT > > aggregation for measure binding on report item has no more sense, so in BIRT, > > there is a special convertion to use SUM instead of COUNT. > > Now fixed this in chart UI, when user select cube set, just doing above rule to > > add measure bindings on report item. > > Please remove old chart from report and insert a new chart to verify this bug. > > This bug is there no matter what chart type you pick... You can not change > the aggregation method on the Series 1 definition. It is greyed out, that is > the point of the bug. > > I have also verified this bug is present in Actuate BIRT Designer Professional > 11. > > This bug is not resolved in my opinion, unless I am missing something. Chart consuming cube is not same as chart consuming data set, cube just supports some special aggregations. So chart consuming cube doesn't support custom aggregation for y series,the aggregation UI is still disabled under this case.
Verified in daily build 2.6.2.v20101222-0630
