Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: How to connect the Mondrian server purely on client side (XML/A access by Ajax)?

  1. #1
    Join Date
    Jan 2016
    Posts
    8

    Default How to connect the Mondrian server purely on client side (XML/A access by Ajax)?

    Hi Team,


    I found the Mondiran documentation and configured Mondrian based on it. But I don’t find the detailed information to access the XML/A directly from the Mondrian server. So how can access the XMLA in Mondrian server using Ajax call? Is there any connection parameter to connect Mondrian BI server through Ajax as below?


    my JavaScript code for accessing XML/A from Mondrian using Ajax call is,


    var MDX = "select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns, {([Promotion Media].[All Media], [Product].[All Products])} ON rows from Sales where ([Time].[1997])";
    $.ajax({
    type: "POST",
    url: "http://localhost:8080/mondrian/xmla",
    data: "<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"> <Header></Header> <Body> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"> <Command> <Statement> " + MDX + " </Statement> </Command> <Properties> <PropertyList> <Catalog>FoodMart</Catalog> </PropertyList> </Properties> </Execute> </Body> </Envelope>",
    success: function (responce, textStatus, jqXHR) {
    console.log(responce);
    },
    contentType: "text/xml",
    dataType: "xml"
    });

    I am getting null value in response argument in success method.

    But, i can able to access Mondrian data base in server side using ADOMD dll. I can't in client side. Can you suggest me how to solve this?

    Regards,
    Ramesh G.
    Last edited by Ramesh_G; 03-14-2019 at 02:57 AM.

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 - 2017 Pentaho Corporation. All Rights Reserved.