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.

When you tried method 2, had you configured http access to SSAS? If not
the following article might get you going:
http://www.microsoft.com/technet/pro.../httpasws.mspx

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1159291711.341515.218840 (AT) h48g2000cwc (DOT) googlegroups.com>,
surendra.p (AT) opussoft (DOT) com says...

Rex (waRehouse EXplorer) is a java client that provides easy-to-use GUI for
browsing multidimensional data sources that support XMLA protocol (Mondrian,
Microsoft Analysis Services 2000 and 2005). Rex also includes MDX editor and
MDX Builder Tool.
http://sourceforge.net/projects/whex

Best regards,

Igor

<surendra.p (AT) opussoft (DOT) com> wrote