compoundMembers.add(new String[] {"USA", "OR"});
compoundMembers.add(new String[] {"CANADA", "BC"});
CellRequestConstraint constraint =
makeConstraintCountryState(compoundMembers);
CellRequest request1 = createRequest(
cubeNameSales2,
measureCustomerCount, new String[]{tableCustomer, tableTime},
new String[]{fieldGender, fieldYear},
new String[]{"M", "1997"}, constraint);
CellRequest request2 = createRequest(
cubeNameSales2,
measureCustomerCount, new String[]{tableCustomer, tableTime},
new String[]{fieldGender, fieldYear},
new String[]{"F", "1997"}, constraint);
CellRequest request3 = createRequest(
cubeNameSales2,
measureCustomerCount, tableTime, fieldYear, "1997", constraint);
String sqlWithoutGS =
"select \"time_by_day\".\"the_year\" as \"c0\", \"customer\".\"gender\" as \"c1\", "