// if this is a single column collapsed level, there is
// no need to join it with dimension tables
RolapStar.Column starColumn =
((RolapCubeLevel) level).getStarKeyColumn();
int bitPos = starColumn.getBitPosition();
AggStar.Table.Column aggColumn = aggStar.lookupColumn(bitPos);
String q = aggColumn.generateExprString(sqlQuery);
sqlQuery.addSelectGroupBy(q);
sqlQuery.addOrderBy(q, true, false, true);
aggColumn.getTable().addToFrom(sqlQuery, false, true);
return sqlQuery.toString();