OracleHierarchy hier = new OracleHierarchy("TIME HIER 3",timeDimension);
hier.setDescription("the Time Dimension main hier");
hier.addLevel(yearLevel);
hier.addLevel(monthLevel);
OracleDimension timeDim = new OracleDimension("TIME DIM 3",hier);
timeDim.setDescription("Time Dimension Descr");
//add it to the oracle data warehouse
dw.addDimension(timeDim);
timeDim.loadObject(connection);
//release database objects
dw.releaseObject();
connection.closeSession(session);