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/
> 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/ > Hi, An interested in the classes that you use to connect without going through the GUI. Can you give some pointers as to the classname/method used as an entry point. Thanks in advance, KC. BizTalk Utilities - Frustration free BizTalk Adapters http://www.topxml.com/biztalkutilities
