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.
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.