Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
415
Issues with connecting to a SSAS CUBE via HTTP Access (Pivot View UI)
posted

Hello,

I'm currently trying to get the igPivotView UI tool to work in my existing MVC application, pulling data remotely from my SSAS tabular model, which my AS has been set-up for HTTP access (followed this guide, https://msdn.microsoft.com/en-us/library/gg492140.aspx).

My issue im trying to resolve is regarding accessing my data through the pivot view tool, my link "http://localhost/olap/msmdpump.dll"  works fine when connecting to excel and i can see my cube and catalogues, as i would expect with this pivot view tool.

But when I try follow the "Adding igPivotView to an ASP.NET MVC Application" guide and add the Pivot View tool into my existing solution and replacing the link from the infragistics cube link to my own local link it seems to fail when trying to connect, and outputs the following error message in the console:

"Failed to load resource: the server responded with a status of 401 (Unauthorized)


PivotGrid:1 XMLHttpRequest cannot load http://localhost/olap/msmdpump.dll. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost:55232' is therefore not allowed access. The response had HTTP status code 401."


Now i believe my IIS is set-up correctly because i am passing basic authentication on the website application and on the application pool i just have the identity set to "ApplicationIdentity" and also my SSAS seems to be set-up correctly with the right privileges, with my username being set in a role which can access the tabular model.

So can anyone provide any help to why i keep getting 401 error's when trying to connect to my tabular model through the pivot view?

Any help is much appreciated, also please find screenshots attached.

Thanks.

Parents
No Data
Reply
  • 16310
    Offline posted

    Hi,

    Thank you for the screenshot shared. It is a straight forward scenario which confirms that issue seems more related to IIS settings than the control configuration. To gain more knowledge on the nature of the issue could you please provide the following info:

    - are you able to access http://localhost/olap/msmdpump.dll using some other way - for example testing the connections using SQL Server Management Studio or Excel

    - does issue only occurs in MVC

    - did you try to set Anonimous authentication instead of Basic and what is the result

    - are you sure your connection string containg user/password for Basic auth is correct

    Looking forward to hearing from you.

Children