Exemplo n.º 1
0
  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;
  }
Exemplo n.º 2
0
  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;
  }