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.
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.
Hello, Thank you for your reply and i will answer your questions in the following bullet points.
- Yes i've been able to access my tabular cube through excel
- To be honest i haven't tried in anything else, only MVC
- Tried the Anonymous authentication, but still had issues with connecting, 401 error.
- When you say connection string, which one do you mean? as didn't know the infragistic pivot viewer sends through a connection string? Can you elaborate more.
Thanks, i look forward to your response.
Hi Rich, since you are able to access it through excel this makes me believe your app just fails to authenticate, I assume you will need a connection string containing the user/password or a step in your app where you enter those. If those are missing it seems expected to fail accessing. I will further investigate this to follow a similar scenario and see what is needed to authenticate and access the cube.
To be honest, i haven't been passing any connection strings within my application, i've only been relying on the request that the pivot view makes to the iis to pass through windows authentication to access the msmdpump.dll through IIS, which then goes and connects through another service account which has access to the analysis services tabular model.
Any help/ideas are highly appreciated!
Thanks
Rich
Developer Martin Pavlov has investigated this issue and suggests trying to set
$.support.cors = true;
This should fix the issue if it is caused by CORS restriction. Please try the suggested and if it does not solve the issue it is recommened to continue discussion in one of the two cases you have opened on this matter.
I'm just following up to see if the suggested helped you or if you need any further assistance on the matter.
Best Regards, Hristo AnastasovAssociate Software DeveloperInfragistics, Inc.