mondrian系列教程(二)

一、多维查询结果分析Result分析：

1.  查看mondrian API文档，我们发现：Result 是一个接口，ResultBase这个抽象类实现了该接口，RolapConnection.NonEmptyResult 和RolapResult继承了该类。
2. 如何访问切片轴?code: Position slicers[] = result.getSlicerAxis().positions;for (int i=0; i<slicers.length; i++) {
                   Position position = slicers[i];
                   for (int k = 0; k < position.members.length; k++) { 
                       Member member = position.members[k];
                       System.out.println(member.getUniqueName());
                   }
               }
3. 如何访问非切片轴? for(int i=0; i<result.getAxes().length; i++)
               {
                Position[] axes = result.getAxes()[i].positions;
                for (int j=0; j<axes.length; j++) {
                    Position position = axes[j];
                       for (int k = 0; k < position.members.length; k++) { 
                           Member member = position.members[k];
                           System.out.println(member.getUniqueName());
                       }
               }
               }

4. 如何访问单元值?

          

 

 

评论

4 楼 huimengshao 2013-01-01  

		Result result = connection.execute(query);

		System.out.println("========== slicers =========");
		List<Position> slicers = result.getSlicerAxis().getPositions();
		for (int i = 0; i < slicers.size(); i++) {
			Position position = slicers.get(i);
			for (int k = 0; k < position.size(); k++) {
				Member member = position.get(k);
				System.out.println(member.getUniqueName());
			}
		}

		System.out.println("=========== axes ===========");
		for (int i = 0; i < result.getAxes().length; i++) {
			List<Position> axes = result.getAxes()[i].getPositions();
			for (int j = 0; j < axes.size(); j++) {
				Position position = axes.get(j);
				for (int k = 0; k < position.size(); k++) {
					Member member = position.get(k);
					System.out.println(""+member.getUniqueName());
				}
			}
		}
		
		System.out.println("=========== cell ===========");
		int[] position1 = {0,0};
		System.out.println(result.getCell(position1).getValue());

		System.out.println("========== result ==========");
		PrintWriter pw = new PrintWriter(System.out);
		result.print(pw);
		pw.flush();

3 楼 fireinjava 2012-05-11  

Result result = connection.execute(query);
PrintWriter pw = new PrintWriter(System.out);
result.print(pw);

取单元格值看下result.print(pw);这代码就知道咋实现的了

2 楼 ruinxdgzy 2010-07-07  

正准备学mondrian，希望有后续教程可供参考！

1 楼 samnia 2009-12-28  

result.getCell(new int[]{j}).getFormattedValue()