private Table getHouseholdFactBaseCubeTable() throws SQLException {
Table householdFactBaseCubeTable = new Table();
householdFactBaseCubeTable.setSizeFull();
householdFactBaseCubeTable.setImmediate(true);
householdFactBaseCubeTable.setColumnCollapsingAllowed(true);
householdFactBaseCubeTable.addContainerProperty("ACCOUNT CITY", String.class, null);
householdFactBaseCubeTable.addContainerProperty("BRANCH CITY", String.class, null);
householdFactBaseCubeTable.addContainerProperty("FISCAL QUARTER", String.class, null);
householdFactBaseCubeTable.addContainerProperty("STATUS REASON", String.class, null);
householdFactBaseCubeTable.addContainerProperty("PRIMARY BALANCE", String.class, null);
householdFactBaseCubeTable.addContainerProperty("TRANSACTION COUNT", String.class, null);
householdFactBaseCubeTable.addContainerProperty("ACCOUNT COUNT", String.class, null);
DecimalFormat formatDecimal = new DecimalFormat("#.##");
ResultSet resultSet = bankService.viewHouseholdBaseCube();
int i = 1;
while (resultSet.next()) {
householdFactBaseCubeTable.addItem(
new Object[] {
resultSet.getObject(1).toString(),
resultSet.getObject(2).toString(),
resultSet.getObject(3).toString(),
resultSet.getObject(4).toString(),
formatDecimal.format((Double) resultSet.getObject(5)).toString(),
resultSet.getObject(6).toString().replace(".0", ""),
resultSet.getObject(7).toString().replace(".0", "")
},
new Integer(i));
i++;
}
return householdFactBaseCubeTable;
}
private Table getHouseholdFactBaseCubeTable() throws SQLException {
Table householdFactBaseCubeTable = new Table();
householdFactBaseCubeTable.setSizeFull();
householdFactBaseCubeTable.setImmediate(true);
householdFactBaseCubeTable.setColumnCollapsingAllowed(true);
householdFactBaseCubeTable.addContainerProperty("ACCOUNT CITY", String.class, null);
householdFactBaseCubeTable.addContainerProperty("HOUSEHOLD STATE", String.class, null);
householdFactBaseCubeTable.addContainerProperty("PRODUCT TYPE", String.class, null);
householdFactBaseCubeTable.addContainerProperty("BRANCH CITY", String.class, null);
householdFactBaseCubeTable.addContainerProperty("PRIMARY BALANCE", String.class, null);
householdFactBaseCubeTable.addContainerProperty("TRANSACTION COUNT", String.class, null);
householdFactBaseCubeTable.addContainerProperty("ACCOUNT COUNT", String.class, null);
DecimalFormat formatDecimal = new DecimalFormat("#.##");
ResultSet resultSet =
bankService.viewHouseholdBaseCubeFourDims(
"a.account_city", "h.household_state", "p.type", "b.branch_city");
int i = 1;
while (resultSet.next()) {
householdFactBaseCubeTable.addItem(
new Object[] {
resultSet.getObject(1).toString(),
resultSet.getObject(2).toString(),
resultSet.getObject(3).toString(),
resultSet.getObject(4).toString(),
formatDecimal.format((Double) resultSet.getObject(5)).toString(),
resultSet.getObject(6).toString().replace(".0", ""),
resultSet.getObject(7).toString().replace(".0", "")
},
new Integer(i));
i++;
}
return householdFactBaseCubeTable;
}