Best Way to Access MS Analysis Services Cube from Java

Question

I want to issue MDX against a MSAS cube from a Java client. What connectivity approaches have proven to be reliable for this?

Answer 1

FWIW I'm using olap4j as the Java client against a MSAS server fronted up by msmdpump.dll. Seems so far to work OK.

Answer 2

Check out http://mondrian.pentaho.org/. This is an OLAP sever with MDX/XMLA support. I understand that what you need is a client but check in the JSP examples that comes with the sever. One example involve MDX queries over XMLA and I think this should give you a start.

Answer 3

This article describes various ways of running MDX queries and extracting results: http://javatip.com/2010/06/frameworks/hibernate/mdx-from-java/