import org.olap4j.OlapConnection;
import org.olap4j.OlapStatement;
import org.olap4j.OlapWrapper;
import org.olap4j.CellSet;

OlapConnection connection = (OlapConnection)DriverManager.getConnection("jdbc:xmla:Server=http://localhost/olap/msmdpump.dll;Catalog=отдел_кадров");		
OlapWrapper wrapper = (OlapWrapper) connection;
OlapConnection olapConnection = wrapper.unwrap(OlapConnection.class);
OlapStatement stmt = olapConnection.createStatement();						

CellSet cellSet = stmt.executeOlapQuery("SELECT [Вакансии].[Код] ON COLUMNS, [Вакансии].[Статус] ON ROWS FROM [куб_1]");

CellSet cellSet = stmt.executeOlapQuery("SELECT FLATTENED * FROM [Возраст и пол].CASES");