locked
PerformancePoint and SSRS Reports - Not using SSRS Web Service? RRS feed

  • Question

  • We have a depoyment of PPS and SSRS (Integrated-mode) with dashboards published in a SharePoint portal.  We have noticed that reports published in a PPS Dashboard do not use the SSRS web services to call the report, rather it loads them directly (as if the dashboard is iframing the report).

    The problem is the users are getting a double auth prompt (as neither the portal or the SSRS report server URL are in their Local Intranet zone), and this likely won't be changing (long story).  Is there any way in PPS to render the report directly in the portal (as it does if you load the RDL directly from a document library?
    Friday, February 19, 2010 4:40 PM

Answers

  • It is using the SSRS web service, that is why are you getting the double auth prompt, once for the portal and the second one for SSRS.  PPS just references these objects, just like it does for ProClarity or Excel Services.  You would really want to get the web site setup as a trusted site.

    The other option I can think out would be to go into the user accounts on the workstations and setup stored credentials for these sites, but that might be a pain and possibly not an option.

    If this doesn't work out then you might want to look at the other reporting options like Analytical Grids or Charts.
    Dan English's BI Blog
    Friday, February 19, 2010 11:19 PM
  • If you are thinking about Extranet scenario then you will want to take a look at this posting and look at the extranet whitepaper - Publishing PerformancePoint Server in extranet scenarios (white paper).  Since PPS will be fully integrated into SharePoint the SSO support will be there.  If you are doing any special type of dynamic security on the SSAS cube if you are referencing one you will need to figure out how you will handle security for external clients if you won't be using Windows Authentication.
    Dan English's BI Blog
    Sunday, February 21, 2010 7:45 PM

All replies

  • It is using the SSRS web service, that is why are you getting the double auth prompt, once for the portal and the second one for SSRS.  PPS just references these objects, just like it does for ProClarity or Excel Services.  You would really want to get the web site setup as a trusted site.

    The other option I can think out would be to go into the user accounts on the workstations and setup stored credentials for these sites, but that might be a pain and possibly not an option.

    If this doesn't work out then you might want to look at the other reporting options like Analytical Grids or Charts.
    Dan English's BI Blog
    Friday, February 19, 2010 11:19 PM
  • We've ended up just using the standard SSRS report viewer in SharePoint, for our current needs it's fine.  Was hoping there was away not to have to expose the SSRS web service URL to clients. There are plans to go extranet with this solution, thus why client side configurations won't work, fortunately SSO will take care of the second auth (not the publishing of the SSRS URL).  The design just seems a little wonky, or at least not what I would expect, hopefully this will change in SP2010.

    Thanks for the input though.
    Sunday, February 21, 2010 7:00 PM
  • If you are thinking about Extranet scenario then you will want to take a look at this posting and look at the extranet whitepaper - Publishing PerformancePoint Server in extranet scenarios (white paper).  Since PPS will be fully integrated into SharePoint the SSO support will be there.  If you are doing any special type of dynamic security on the SSAS cube if you are referencing one you will need to figure out how you will handle security for external clients if you won't be using Windows Authentication.
    Dan English's BI Blog
    Sunday, February 21, 2010 7:45 PM