Examples of rex.metadata.resultelements.Cell

  public void testExecute() {
    try
    {
      // Result of following Query should be 266773.
      // SELECT NON EMPTY {[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY {[Time].[1997]} ON ROWS FROM [Sales]
      Assert.assertEquals("266773",(new Cell((((port1.execute(mdxQuerySales,execPropFoodMart)).getElementsByTagName("CellData")).item(0).getChildNodes()).item(1))).getCellValue());
      // Result of following Query should be 66984555.
      // SELECT NON EMPTY {[Measures].[nQuantity]} ON COLUMNS, NON EMPTY {[Time].[2006]} ON ROWS FROM [Inventory]
      Assert.assertEquals("66984555",(new Cell((((port1.execute(mdxQueryInv,execPropInventory)).getElementsByTagName("CellData")).item(0).getChildNodes()).item(1))).getCellValue());      
    }
    catch(Exception exc)
    {
      System.out.println("From TestExecute Exception");
      System.out.println("Exception Error"+exc.getMessage());

      execPropFoodMart.setDataSourceInfo("FoodMartSource");
    execPropFoodMart.setCatalog("FoodMart");
      String mdxQuerySales="SELECT NON EMPT {[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY {[Time].[1997]} ON ROWS FROM [Sales]";
      try {
      //svm.execute(mdxQuerySales,execPropFoodMart);
      System.out.println((new Cell((((svm.execute(mdxQuerySales,execPropFoodMart)).getElementsByTagName("CellData")).item(0).getChildNodes()).item(1))).getCellValue());
      }
      catch(java.io.IOException io)
    {
        System.out.println(io.toString());        
    }

Examples of rex.metadata.resultelements.Cell

Related Classes of rex.metadata.resultelements.Cell