I can get the pivotgrid to work when hosting the web application on the same server as the olap web folder. However, this only works for our development environment.

When trying to get it to work, using an olap folder hosted on a different server to the web application (i.e. on our analysis services server), the call to the olap url returns a '401:Access denied due to invalid credentials' error.

I've followed the directions (as they are) to add cross domain access. I've added the http response headers (screenshot attached), and set the OPTIONSVerbHandler access to read.

Is there anything else I need to do? Or are there any troubleshooting steps?  There doesn't seem to be a lot about http access to analysis services on the web (at least that's about anything but management studio), so some more in-depth guidance on how to get a pivotgrid working would be appreciated.




​

Hello Shuja,

You are right that there isn't a complete tutorial that describes how to setup OLAP instance and enable IIS CORS. Nevertheless, the available ones can help you setup your OLAP instance. Once this is done, you can enable CORS and test it using Fiddler for instance or event Kendo UI PivotGrid. I will suggest you check our documentation on the topic.
Unfortunately, I will not be able to assist you further with the infrastructure setup as it is not directly related to Kendo UI PivotGrid widget and its functionality.

Regards,
Georgi Krustev
Telerik