Connecting OLAP Cube through JQuery.ajax() – XML/A

Question

I have configured HTTP access (msmdpump.dll) for SSAS to access OLAP Cube online as provided in the below blog. And now cube can be accessed using msmdpump.dll through remote connection by providing appropriate connection string. https://msdn.microsoft.com/en-us/library/gg492140.aspx

At same time, I have trying to access the cube through XML/A concept from JQuery.ajax () like below,

var MDX = " SELECT   {[Date].[Fiscal]  ON COLUMNS ,  {[Measures].[Customer Count]}  ON ROWS  FROM [Adventure Works] ;             
$.ajax({
            type: "POST",
            url: "http://localhost:6078/olap/msmdpump.dll",
            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>Adventure Works DW Standard Edition</Catalog> </PropertyList> </Properties> </Execute> </Body> </Envelope>",
            success: function (responce, textStatus, jqXHR) {
                                                            $('body').append(responce);
            },
            contentType: "text/xml",
            dataType: "xml",
        });

But it throws “XMLHttpRequest cannot load http://localhost:6078/olap/msmdpump.dll. Response for preflight has invalid HTTP status code 500” exception, since we have missed to configure cross orgin-domain support for IIS to access the OLAP data. And I have got answer by raising the following forum,

https://social.technet.microsoft.com/Forums/forefront/en-US/03e4f14e-3301-40b4-b00b-d81ca7b07ce7/xmlhttprequest-cannot-load-httplocalhostolapmsmdpumpdll-response-for-preflight-has-invalid?forum=sqlanalysisservices&prof=required

Here, I successfully provided the cross-orgin domain to the IIS for non-authenticate access for OLAP application directory (node for creating access to the msmdpump.dll) as mentioned in the below blog. http://www.igniteui.com/help/igolapxmladatasource-configuring-iis-for-cross-domain-olap-data#summary

Finally I have stuck with following exception,

“XMLHttpRequest cannot load http://localhost:6078/olap/msmdpump.dll. Request header field Content-Type is not allowed by Access-Control-Allow-Headers in preflight response.”

Please advise me,

Is there anything additional configuration required for IIS ?

NOTE: Also, i have provided network access to my port (which is, connection string hosted port).

Pranath Pranath · Accepted Answer · 2016-02-03T03:55:12

Problem is resolved for me after hosting my sample in IIS. While i am trying from "file:///C:/Users/prabus/Desktop/Sample/xmlaaccess.html" local path i can't able to access the msmdpump.dll(which is hosted in same machine). So, localhost is not accessible from local file path.

Connecting OLAP Cube through JQuery.ajax() – XML/A

1 Answers