olap through java

[swaroop]

Hi,
I meed some help.
I have MS SQL server as my backend for warehouse. I want to fire MDX queries to MS SQL server through JAVA n I m looking for connectivity of OLAP features of MS SQL server n JAVA for the same.
Plz reply if anyone has the answer. It's very urgent.
Thanks
SWAROOP

[mnuttall]

http://mondrian.sourceforge.net/
http://jpivot.sourceforge.net/
http://rubik.sourceforge.net/

[swaroop]

I know those links.
But the problem is that I have prepared OLAP cubes in MS SQL server.
I want to know how should i use jpivot,mondrian for MS SQL server.
If yes, what should I do to connect. What is the diff?
Please do reply......
Its very urgent.....
waiting!!!!!
Thanks
SWAROOP

[mnuttall]

I've not used it that way. You'll need to ask them on their forums or dig through their websites.

[swaroop]

Thanks for ur support n suggestion.