通过JQuery.ajax（）连接OLAP多维数据集-XML/A.-ConnectingOLAPCubethroughJQuery.ajax()–XML/A

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

我为SSAS配置了HTTP访问(msmdpump.dll),以便在线访问OLAP Cube,如下面的博客所示。现在可以通过提供适当的连接字符串,通过远程连接使用msmdpump.dll访问多维数据集。 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,

同时,我试图通过JQuery.ajax()中的XML / A概念访问多维数据集,如下所示,

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: "      " + MDX +"     Adventure Works DW Standard Edition     ",
            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,

但它抛出“XMLHttpRequest无法加载http:// localhost:6078 / olap / msmdpump.dll。对于预检的响应具有无效的HTTP状态代码500“异常,因为我们错过了为IIS配置交叉orgin-domain支持以访问OLAP数据。我通过提出以下论坛得到了答案,

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

在这里,我成功地向IIS提供了交叉域,以便对OLAP应用程序目录(用于创建对msmdpump.dll的访问的节点)进行非身份验证访问,如下面的博客中所述。 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.”

“XMLHttpRequest无法加载http:// localhost:6078 / olap / msmdpump.dll。请求标题字段在预检响应中,Access-Control-Allow-Headers不允许使用Content-Type。“

Please advise me,

请建议我,

Is there anything additional configuration required for IIS ?

IIS是否还需要其他配置?

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

注意:此外,我已经提供了对我的端口(连接字符串托管端口)的网络访问。

1 个解决方案