PivotGrid with SSAS on another server

[AP]

A web application in development will be hosted on a different IIS server to the IIS server hosting the OLAP msmdpump.dll web application.

 I can get the pivotgrid working setting the OLAP web application to anonymous access, and giving the anonymous user access to the cube. However, this is not secure. Ideally we would like to be able to specify that the pviotgrid should access the web application using the application pool identity of the application (which is a domain account). Have you any ideas on how to do this?

As a last resort, how would the pivotgrid be configured when using basic authentication? How would the username and password be specified in the configuration?

 Thanks

 

[Georgi Krustev]

Hi,

The suggested approach for binding to a SASS instance that requires an authentication is to use a server proxy. The proxy will request the cube and will perform the authentication hidden for the widget. This is the preferred way, because thus you will not expose sensitive information to the client (browser).

In the Microsoft world the solution is to use ADOMD. This is discussed in this forum thread.

The other option is to send the credentials with a request header, even though thus the username and password will be visible on the client side (browser). If this is the way you would like to go, then I will suggest you review this StackOverflow discussion to understand how to pass credentials with request headers. You can pass the required callbacks and setting to the transport.read object as it is passed directly to $.ajax.

Regards,
Georgi Krustev
Telerik

[AP]

Thanks for your reply.

I had seen that forum post. Unfortunately it doesn't cover how to set up the proxy, just how to use the pivot grid with an ADOMD source.

I appreciate you're only the control developers, but there is a distinct lack of documentation around http access to analysis services, which make implementing any PivotGrid solution a challenge.

However, I think we're going to use the Silverlight PivotGrid in our application. as it avoids the two-hop authentication issues, and currently provides a better user experience in our view.