Bug 211849 [Regression]Grandtotal's results is incorrect
Description: The Grandtotal's result is incorrect in report which is created in v20071204-0800 build, first I think it is data's bug. But the same report created in former build and preview in this build, the result is correct. So may be the crosstab created in today's build is incorrect. Build number: 2.3.0.v20071204-0800 Steps to reproduce: 1, New a crosstab with row and column dimensions 2, Define grandtotals on both row and column dimension 3, Preview Expected result: The grandtotal's result should be correct Actual result: The grandtotal's result is incorrect Error log:
data/org.eclipse.birt.data.tests/test/org/eclipse/birt/data/engine/olap/api/CubeFeaturesTest.java
IBinding binding11 = new Binding( "dist_total" );
		binding11.setExpression( new ScriptExpression( "measure[\"measure1\"]" ) );
		binding11.setAggrFunction( IBuildInAggregation.TOTAL_SUM_FUNC );
		binding11.addAggregateOn( "dimension[\"dimension1\"][\"level11\"]" );
		binding11.addAggregateOn( "dimension[\"dimension1\"][\"level12\"]" );
		binding11.addAggregateOn( "dimension[\"dimension1\"][\"level13\"]" );
		cqd.addBinding( binding11 );
		IBinding binding12 = new Binding( "city_total" );
		binding12.setExpression( new ScriptExpression( "measure[\"measure1\"]" ) );
		binding12.setAggrFunction( IBuildInAggregation.TOTAL_SUM_FUNC );
		binding12.addAggregateOn( "dimension[\"dimension1\"][\"level11\"]" );
		binding12.addAggregateOn( "dimension[\"dimension1\"][\"level12\"]" );
		cqd.addBinding( binding12 );
		IBinding binding13 = new Binding( "country_total" );
		binding13.setExpression( new ScriptExpression( "measure[\"measure1\"]" ) );
		binding13.setAggrFunction( IBuildInAggregation.TOTAL_SUM_FUNC );
		binding13.addAggregateOn( "dimension[\"dimension1\"][\"level11\"]" );
		cqd.addBinding( binding13 );
	}
	private void printCube( CubeCursor cursor, String country_year_total,
			String city_year_total, String dist_total, String city_total,
			String country_total, String year_total, String grand_total,
			String[] columns, String row, String measure )
			throws OLAPException, IOException
	{
		printCube( cursor, country_year_total,
				city_year_total, dist_total, city_total,
				country_total, year_total, grand_total,
				columns, row,  measure, true );
	}