SSRS Integrated Mode and SSAS delegation issue
We have setup SharePoint 2010 with SSRS 2008 R2 and all the Kerberos goodies to do delegation. However, we have a small issue that I believe is due to caching. We setup roles in the cube that restricts what a user can see. If we access the report in SharePoint
with a user who belongs to the restricted role, everything is trimmed as expected. However, if we access the report immediately as the user who is not restricted they see the restricted data. If we wait a couple of minutes and do the same steps only switch
which user goes first, unrestricted data is displayed. If we do an IIS/SSRS reset in between the two tests, everything works as expected. Where should I be looking for caching? SharePoint, SSRS, SSAS? Any ideas are welcome.
July 2nd, 2011 3:03pm
You can check for instance caching on the report under the report execution propertes. With instance caching disabled for a deployed report, each user shuld get a fresh copy of the report and see the results of a new query each time.Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 3:27am


