We are using “Mondrian.war” for XML for Analysis on non-embedded database and Mondrian.war has been stopped from Mondrian 3.6.0 version. So how can we use Mondrian XML/A support for newer versions for non-embedded data source as provided in the document? And we are using below code to fetch data from XML/A connection,
Code:
    $.ajax({
                type: "POST",
                url: "http://localhost:8080/mondrian/xmla",
                data: '<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" flexmonster="true"><SOAP-ENV:Body><Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><Command><Statement><![CDATA[with member [Measures].[CountAllMembers] as Count([Time.Weekly].allmembers) select NON EMPTY {[Measures].[CountAllMembers]} ON columns FROM [Sales]]]></Statement></Command><Properties><PropertyList flexmonster="true"><DataSourceInfo>Provider=mondrian;DataSource=MySQLTest;</DataSourceInfo><Catalog>FoodMart</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content><Format>Multidimensional</Format></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>',
                success: function (responce, textStatus, jqXHR) {
                    alert("Mondrian - XMLA - Success!!!");
                },
                contentType: "text/xml",
                dataType: "xml",
            });