import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.List;

import org.olap4j.* ; 

import org.apache.xerces.parsers.DOMParser ; 



public class test2 {

public static void main(String[] args) {



		try {

			Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");

		} catch (ClassNotFoundException e) {

			

			e.printStackTrace();

		}

		try {

			OlapConnection con = (OlapConnection)DriverManager.getConnection("jdbc:xmla:Server=http://localhost/olap/msmdpump.dll;");

		

		 

		OlapWrapper wrapper = (OlapWrapper) con;

		OlapConnection olapConnection = (OlapConnection) wrapper.unwrap(OlapConnection.class);

		OlapStatement stmt = olapConnection.createStatement(); 



		CellSet cellSet = stmt.executeOlapQuery("select {[Dim Account].[Account Description].[Account Description]}ON Columns, {[Measures].[Amount]} ON Rows from [financecube];");

		

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		

	

		 	}

}