import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.olap4j.CellSet;
import org.olap4j.OlapConnection;
import org.olap4j.PreparedOlapStatement;
import org.olap4j.layout.CellSetFormatter;
import org.olap4j.layout.RectangularCellSetFormatter;




import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.olap4j.CellSet;
import org.olap4j.OlapConnection;
import org.olap4j.PreparedOlapStatement;
import org.olap4j.layout.CellSetFormatter;
import org.olap4j.layout.RectangularCellSetFormatter;


Connection jdbcConn = DriverManager.getConnection(
    "jdbc:mondrian:" +
    "JdbcDrivers=com.mysql.jdbc.Driver" +
    "Jdbc=jdbc:mysql://localhost:3306/seasa" +
    "Catalog=res:com/compmakeart/ceasa.xml");

OlapConnection olapConn = jdbcConn.unwrap(OlapConnection.class);

PreparedOlapStatement olapSt = olapConn.prepareOlapStatement(
    "SELECT [Measure].[Quantidade] ON COLUMNS, " +
    "[Localizacao].[All Regiaos] OR ROWS");

CellSet cellSet = olapSt.executeQuery();

CellSetFormatter format = new RectangularCellSetFormatter(false);
format.format(cellSet, new PrintWriter(System.out));