从Java访问MS Analysis Services Cube的最佳方式

import com.microsoft.analysisservices.AdomdClient.*;

public class AdomdExample {
    public static void main(String[] args) {
        try {
            String connectionString = "Data Source=<server>;Initial Catalog=<database>;User ID=<username>;Password=<password>;";
            AdomdConnection conn = new AdomdConnection(connectionString);
            conn.open();

            String mdxQuery = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, [Product].[Category].Members ON ROWS FROM [Adventure Works]";
            AdomdCommand cmd = new AdomdCommand(mdxQuery, conn);
            CellSet cellSet = cmd.executeCellSet();

            for (int row = 0; row< cellSet.getAxes().get(1).getPositions().size(); row++) {
                for (int col = 0; col< cellSet.getAxes().get(0).getPositions().size(); col++) {
                    Cell cell = cellSet.getCell(col, row);
                    System.out.print(cell.getValue() + "\t");
                }
                System.out.println();
            }

            conn.close();
        } catch (AdomdErrorException | AdomdConnectionException e) {
            e.printStackTrace();
        }
    }
}