Saturday, February 25, 2012

MDX queries on SQL Server OLAP using Java

Hi,

We are trying use MS SQL Server OLAP and we want to fire MDX queries to SQL Server OLAP using Java. Can someone guide me on how can we do this?

Regards,

~Kanchan.

As an example you can take a look at this open source project: REX http://sourceforge.net/projects/whex/

It is written in Java, and it is general purpose OLAP client tool which works against Analysis Services. Since it's open source you can go through the code and see how it works.

HTH,

Mosha (http://www.mosha.com/msolap)

No comments:

Post a Comment