Some time ago I posted regarding problems connecting to Analysis Services
using Java. Many thanks to posters who replied but I never got it to
work... until now. For the record and future developers with the same
problem this is how I did it:
I used REX - a brilliant set classes complete with front-end by Igor
Ludi to browse AS cubes. I did not use the GUI front-end, but just the
classes and methods for connecting to AS. These took care of a lot of the
guesswork and ambiguity with the connection parameters as I was able
to use REX to establish these. Once the ambiguities were out of the way,
it was simply a question of using the correct methods to retrieve the data
into my own structures without using the GUI bits.
I hope to contribute whatever I have done to the project in due course but
in the meantime, the URL to REX is http://sourceforge.net/projects/whex/
|