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.
