hi i am a java devloper and new to sql server and OLAP..
can any one tell me how to connect to sql server OLAP services with java...
my requirement is to generate reports using cubes data in java ...

thanx in advance....

I don't know if there is a "direct" way but you can try following:

for querying data
- register olap server in the sql server as linked server
- connect to the sql server via jdbc
- use select statement like :
select * from
openquery(linked_olap, ' const MDX statement')
where
<some filter>


for accessing the cube structure you need to interact with the DSO
components (COM). I don't know if there are some "wrappers" for com for
java.

-radu

"ashok amara" <ashok amara (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:452559D6-75C3-49CE-8CD1-6FED3E272E0C (AT) microsoft (DOT) com...

The simplest way is to do it through XMLA protocol.
Here are links to some open source client tools written in Java which work
against AS through XMLA (some of them are pure client, others are JSP)

REX: http://i.zpm.fer.hr/rex/
JPivot: http://sourceforge.net/projects/jpivot
JRubik: http://sourceforge.net/projects/rubik

There are also some open source projects which aren't client tools, but
connectivity libraries to XMLA in Java - however I don't know how
good/bad/working/maintained they are

XMLA Processor: http://sourceforge.net/projects/xmlaprocessor
JXMLA: http://sourceforge.net/projects/jxmla

HTH,
Mosha

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"ashok amara" <ashok amara (AT) discussions (DOT) microsoft.com> wrote