RE: Connecting to MS Olap though JSP - need help
- From: "Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.paradistc.org/liberi"<liberi9606@xxxxxxxxx>
- Date: Wed, 14 Mar 2007 19:53:39 GMT
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.
Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.paradistc.org/liberi
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities
.
- Prev by Date: Re: Connecting to MS Olap though JSP - need help
- Next by Date: RE: Connecting to MS Olap though JSP - need help
- Previous by thread: RE: Connecting to MS Olap though JSP - need help
- Next by thread: RE: Connecting to MS Olap though JSP - need help
- Index(es):
Relevant Pages
|
|
