Connecting to MS Olap though JSP - need help

Hello All,

Please suggest solution on how to connect to MS Olap through Java.
I would appreciate any help on this topic.

I have tried
1. Mondrian : It is an OLAP and so no information on MS OLAP
connectivity
2. jPivot : All the examples are with Mondrian. In Help there is 5
lines code given for MS OLAP
---------------------
<jp:xmlaQuery
       id="query01"
       uri="http://localhost/xmla/msxisapi.dll"
       catalog="Foodmart 2000">
        select {[Measures].[Unit Sales]} on columns,
        [Product].[All Products].children on rows
        from Sales where ([Time].[1997])
    </jp:xmlaQuery>

--------------------
 which does not work and it gives error
-----------------------
javax.servlet.ServletException: Soap Fault
code=XA:XMLAnalysisError.80040154 fault string=An error occurred while
processing the request. fault
actor=urn:schemas-microsoft-com:xml-analysis detail:ErrorCode =
2147746132; Description = ; Source =
urn:schemas-microsoft-com:xml-analysis
-----------------------

3. OpenI : IT is again same as jPivot and gives the same error

4. OPENROWSET : This solution is not suitable for my project as this
used linked DB and OLAP.
--------------------------
SELECT * FROM
OPENROWSET('MSOLAP.2','DATASOURCE=Tutorial;CATALOG=Foodmart
2000;UID=;PWD=','select {[Measures].[Unit Sales]} on columns,
        [Product].[All Products].children on rows
        from Sales where ([Time].[1997]')
--------------------------

Please help and suggest.

Thanks & Regards,
Surendra P.