Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: [Mondrian XMLA] Retrieve Data Urgent

  1. #1
    Join Date
    May 2011
    Posts
    4

    Default [Mondrian XMLA] Retrieve Data Urgent

    Hi everyone,

    I would use the following functions for retrieving the data:

    - List discoverDSProps ():
    - List discoverCube (String cat)
    - List discoverDim (String cat, String cube)
    - List discoverHier (String cat, String cube, String size)
    - List discoverLev (String cat, String cube, String size, String last)

    They come to XMLA_SOAP.class, but I can't even use this class on a simple JSP page with the database FoodMart..

    Code:
    <%@ page import="mondrian.olap.Util,
                     mondrian.xmla.test.XmlaTestContext,
                     org.apache.log4j.Logger,
             com.tonbeller.jpivot.xmla.*,
             mondrian.xmla.test.XmlaTestServletRequestWrapper,
             java.util.*"%>
    <%@ page language="java" %>
    
    <html>
    <head>
    <title>Mondrian XML for Analysis Tester</title>
    </head>
    <body>
    <% 
       // Creation de configuration SOAP
       XMLA_SOAP olap = new XMLA_SOAP("http://xmla.jsp", null, null, "Provider=Mondrian;DataSource=MondrianFoodMart;");
    
    %>
    
    <!-- Retrieve Data Source Propreties -->
    
    Liste des proprietes DataSource : <%=olap.discoverDSProps()%>
    
    </body>
    </html>
    I think I may have badly used the function XMLA_SOAP: I need a uri, login and password, you can add either the catalog either the provider. The worry is that I do not know what to put in these settings and I do not know what we must uri user here ...
    Here's the error I have:

    Code:
    org.apache.jasper.JasperException: Exception in JSP: /xmlaTest3.jsp:34
    
    31: 
    32: <!-- Retrieve Data Source Propreties -->
    33: 
    34: Liste des proprietes DataSource : <%=olap.discoverDSProps()%>
    35: 
    36: </body>
    37: </html>
    
    
    Stacktrace:
    	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    cause mère 
    javax.servlet.ServletException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
    	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
    	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
    	org.apache.jsp.xmlaTest3_jsp._jspService(xmlaTest3_jsp.java:79)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    cause mère 
    com.tonbeller.jpivot.olap.model.OlapException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
    	com.tonbeller.jpivot.xmla.XMLA_SOAP.discover(XMLA_SOAP.java:1453)
    	com.tonbeller.jpivot.xmla.XMLA_SOAP.discoverDSProps(XMLA_SOAP.java:247)
    	org.apache.jsp.xmlaTest3_jsp._jspService(xmlaTest3_jsp.java:68)
    	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    I need help.

    Also I have another question, is it possible to retrieve the result of the XML for Analysis tester in tabular form (like Basic interface for ad hoc queries)?

    Thanks and regards, Darkfeather

  2. #2
    Join Date
    Apr 2011
    Posts
    3

    Default

    I've had a lot of issues with XMLA, but finally have them solved. There seem to be some issues with using some versions of IE and issues with JDK 1.6. I moved my testing to Firefox and followed a couple of workarounds (mainly xalan) from the site below.

    http://davidghedini.blogspot.com/201...ntos-with.html

  3. #3
    Join Date
    May 2011
    Posts
    4

    Default [Mondrian XMLA] Retrieve Data

    Thank you for responding, but the problem is not in the configuration of Mondrian, everything works.
    I want to create a JSP page where it retrieves the following functions

    - List discoverDSProps ():
    - List discoverCube (String cat)
    - List discoverDim (String cat, String cube)
    - List discoverHier (String cat, String cube, String size)
    - List discoverLev (String cat, String cube, String size, String last)

    But I must use the function XMLA_SOAP (String uri, String login, String password, String dataSource), and I do not know What's this I need to uri. Otherwise, if someone has a solution to reuse the results with XML for Analysis tester and I can reuse the values ​​in a JSP I would like to know ...

  4. #4
    Join Date
    May 2011
    Posts
    4

    Arrow [Mondrian XMLA] An other error

    I found a solution that matched my expectations: xmla4js.
    But here also still a problem: I would like to view the XMLA response in the form of a table.
    This is a problem that I can not solve.
    Thank you for helping me so quickly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.