Bug 182296 Crosstab - non-numeric measures
Feature request. Looking at the 2.2.M6 release, it seems that measures (the fields that can be in the matrix part of the output) need to be numeric. I looked at the spec documents and it seems there is no requirement for non-numeric measures
data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/impl/DataSetIterator.java
}
		prepareMeasure( cubeHandle, query, resultMetaList );
		this.it = session.prepare( query ).execute( null ).getResultIterator( );
		populateMeta( levelNameColumnNamePair, resultMetaList );
	}
	/**
	 * 
	 * @param cubeHandle
	 * @param query
	 * @param resultMetaList
	 */
	private void prepareMeasure( TabularCubeHandle cubeHandle,
			QueryDefinition query, List resultMetaList )
	{
		List measureGroups = cubeHandle.getContents( CubeHandle.MEASURE_GROUPS_PROP );
		for ( int i = 0; i < measureGroups.size( ); i++ )
		{
			MeasureGroupHandle mgh = (MeasureGroupHandle) measureGroups.get( i );
			List measures = mgh.getContents( MeasureGroupHandle.MEASURES_PROP );
			for ( int j = 0; j < measures.size( ); j++ )
			{
				MeasureHandle measure = (MeasureHandle) measures.get( j );
				String function = measure.getFunction( );
				if ( query.getGroups( ).size( ) > 0 )
				{
					ScriptExpression se = populateExpression( query,
							measure,
							function );
					query.addResultSetExpression( measure.getName( ), se );
				}