Bug 190419 The topn filter doesn't take effect on the datetime type dimension[1102]
Description: The topn filter doesn't take effect on the datetime type dimension[1102] Build number: 2.2.0.v20070601-1347 Steps to reproduce: 1, New a crosstab which includes datetime type dimension 2, Specify a filter on the year level using two filter condition data["year"] topn 2 or dimension["Date"]["year"] topn 2 3, Preview Expected result: Both filter condition can take effect Actual result: No effect only 2005 year in crosstab
data/org.eclipse.birt.data.tests/test/org/eclipse/birt/data/engine/olap/api/CubeFeaturesTest.java
measureColumnName[0] = "measure1";
		Cube cube = new Cube( cubeName, documentManager );
		cube.create( getKeyColNames(dimensions), dimensions, factTable2, measureColumnName, new StopSign( ) );
		
		cube.close( );
		documentManager.close( );
	}
	
	/**
	 * 
	 * @param dimensions
	 * @return
	 */
	private static String[][] getKeyColNames( IDimension[] dimensions )
	{
		String[][] keyColumnName = new String[dimensions.length][];
		for ( int i = 0; i < dimensions.length; i++ )
		{
			ILevel[] levels = dimensions[i].getHierarchy( ).getLevels( );
			ILevel detailLevel = levels[levels.length-1];
			keyColumnName[i] = detailLevel.getKeyNames( );
		}
		return keyColumnName;
	}
	private String[] distinct( String[] values )
	{
		String[] lValues = new String[values.length];
		System.arraycopy( values, 0, lValues, 0, values.length );
		Arrays.sort( lValues );
		List tempList = new ArrayList( );