//create oracle dimension
RelationalTable timeDimension = new RelationalTable("TIMEDIMENSIONTEST");
timeDimension.loadObject(connection);
OracleLevel yearLevel = new OracleLevel("YEAR 3",timeDimension,"YEAR");
yearLevel.setDescription("the year of shipment");
OracleLevel monthLevel = new OracleLevel("MONTH 3",timeDimension,"MONTH");
monthLevel.setDescription("the month of shipment");
OracleHierarchy hier = new OracleHierarchy("TIME HIER 3",timeDimension);
hier.setDescription("the Time Dimension main hier");
hier.addLevel(yearLevel);
hier.addLevel(monthLevel);