Package ch.epfl.lbd.database.providers.oracle.olap

Examples of ch.epfl.lbd.database.providers.oracle.olap.OracleDataWarehouse$AnalyticalWorkspace


      UserSession session = connection.openSession();
     
      ArrayList<String> tbls = connection.getAnalyticalWorkspaces();
      for(String table : tbls)logger.info("AWS: "+table);
     
      OracleDataWarehouse dw = new OracleDataWarehouse("owner","NEWJAVA_AW_TEST");
      dw.loadObject(connection);
     
      tbls = connection.getAnalyticalWorkspaces();
      for(String table : tbls)logger.info("AWS: "+table);
     
//      workspace.deleteAW(); 
View Full Code Here


      connection.multiDimensional = true;
      connection.openConnection();
     
      UserSession session = connection.openSession();

      OracleDataWarehouse dw = new OracleDataWarehouse("owner","NEWJAVA_AW_TEST");
      dw.loadObject(connection);
     
      ArrayList<String>  tbls = connection.getAnalyticalWorkspaces();
      for(String table : tbls)logger.info("AWS: "+table);
     
      //OracleCube cube = new OracleCube("TEST_CUBE",workspace.getName(),connection);
View Full Code Here

      OracleConnection connection = new OracleConnection("zhixian-machine.xml");
     
      connection.openConnection();
      UserSession session = connection.openSession();
     
      OracleDataWarehouse dw = new OracleDataWarehouse("SIMONE","DW_2");
      dw.loadObject(connection);
     
      //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);
     
      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)
      connection.closeConnection();
    }
    catch (Exception e) {
View Full Code Here

TOP

Related Classes of ch.epfl.lbd.database.providers.oracle.olap.OracleDataWarehouse$AnalyticalWorkspace

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.