Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Data XML Analysis > Connecting to M...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 16 Topic 536 of 568
Post > Topic >>

Connecting to MS Olap though JSP - need help

by surendra.p@[EMAIL PROTECTED] Sep 26, 2006 at 10:28 AM

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.
 




 16 Posts in Topic:
Connecting to MS Olap though JSP - need help
surendra.p@[EMAIL PROTECT  2006-09-26 10:28:31 
Re: Connecting to MS Olap though JSP - need help
Darren Gosbell <jam@[E  2006-09-27 20:22:31 
Re: Connecting to MS Olap though JSP - need help
"Igor" <igor  2006-10-09 09:43:50 
RE: Connecting to MS Olap though JSP - need help
"Great site you http  2007-03-09 12:44:48 
Re: Connecting to MS Olap though JSP - need help
Igor <igor@[EMAIL PROT  2007-03-14 10:32:06 
RE: Connecting to MS Olap though JSP - need help
"Nice site you have!  2007-03-12 04:22:11 
RE: Connecting to MS Olap though JSP - need help
"Du musst ein Fachma  2007-03-14 19:53:39 
RE: Connecting to MS Olap though JSP - need help
"pagine piuttosto in  2007-03-16 19:39:58 
RE: Connecting to MS Olap though JSP - need help
"luogo grande:) ness  2007-03-18 11:05:50 
RE: Connecting to MS Olap though JSP - need help
"Great site! Good lu  2007-03-20 02:04:37 
RE: Connecting to MS Olap though JSP - need help
"Lavoro eccellente!   2007-03-20 21:34:56 
RE: Connecting to MS Olap though JSP - need help
"Interessieren. SEHR  2007-03-31 02:57:55 
RE: Connecting to MS Olap though JSP - need help
"Du musst ein Fachma  2007-03-31 07:03:17 
RE: Connecting to MS Olap though JSP - need help
"L'information inter  2007-03-31 11:11:12 
RE: Connecting to MS Olap though JSP - need help
"Ich erklare meinen   2007-03-31 15:09:30 
RE: Connecting to MS Olap though JSP - need help
"Grande sito!! http:  2007-03-31 19:05:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 9:03:03 CST 2008.