PivotGrid with SSAS on another server

3 posts, 0 answers
  1. AP
    AP avatar
    210 posts
    Member since:
    Apr 2010

    Posted 01 Jun 2015 Link to this post

    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?



  2. Georgi Krustev
    Georgi Krustev avatar
    3742 posts

    Posted 03 Jun 2015 Link to this post


    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.

    Georgi Krustev
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. AP
    AP avatar
    210 posts
    Member since:
    Apr 2010

    Posted 03 Jun 2015 in reply to Georgi Krustev Link to this post

    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.

Back to Top