Environment: Windows Server 2008 R2 Enterprise; SQL Server 2012 Enterprise (SSRS SharePoint Integrated Mode); SharePoint 2010 Enterprise We are experiencing, what appears to be a caching problem, when interacting with a SSRS report that is been displayed via a PerformancePoint Report Web Part. The report comprises of a bar chart and a table, and is interactive (e.g. you can change the month by clicking on a column in the chart). When first opened, the report renders correctly - when we change month by clicking on the chart, the chart updates after the first click, but then is always one-click behind thereafter, for example: We click: Table displays: Chart displays: April column in chart 2012 Apr April as current month January column in chart 2012 Jan April as current month October column in chart 2011 Oct January as current month September column in chart 2011 Sep October as current month We have tested the report as a pure SSRS report in SharePoint and it functions correctly. We have also tried adding the report to PerformancePoint dashboard and deploying the entire dashboard (i.e. not using Web Parts) and we still have the caching issue. Has anyone experienced (and resolved) a similar issue?

Hi Mathew, I am unsure how you are trying to refresh the chart based on the click of a column. Here's what I would suggest you to try: 1. Make use of URL access to make render the chart upon the click of a column. 2. In the URL, include the rs:ClearSession=True - this will clear the report from that report session. You can read more about this at the below link: http://msdn.microsoft.com/en-us/library/ms153610%28v=sql.105%29.aspx Let me know if you need more info. If the above does not help you, can you share more info on how you are refreshing the chart by clicking on one of its columns? HTH. Cheers, IceQB Please mark correct answers :)

Thanks IceQB, Here is a link to a short video demonstrating our issue http://screencast.com/t/XkuHuF1MF8M When I click on the month column, the table (below the chart) updates and the clicked column should change colour (to signify selected month) - the column changes colour when I make my first selection but then it always lags one behind my subsequent selections. This report interaction is achieved by simply utilising the Action option under the chart's Series Properties http://screencast.com/t/wvj2YyLR We recall the report using =Globals!ReportName and pass the month relating to the selected column to the time parmeter. The caching problem only occurs when viewing the report as a PerformancePoint report. Here is the same report working correctly in SSRS (SharePoint integrated mode) http://screencast.com/t/yilfJ2Udg - note the 'white screen' pause as the report refreshes, this doesn't happen with the PerformancePoint report. I am not familiar with using URL access to render the chart - can you give me more information on how I would apply this? However, I am leaning towards this being a PPS issue (as it works fine in SSRS). Thanks again! Mathew.

Hi Mathew, Firstly, I must say - I am so very impressed with the way you conveyed your issue via the videos! Simply makes things so much more easier for everyone. Thanks for going the video way and keeping it precise. Here's what you can try doing: 1. Go to the Actions property for the chart series (as in your second video) and modify the Action setting from "Go to report" to "Go to URL". and then click on the fx button; as shown in the below screenshot: 2. Once in the expression editor, please enter the URL for the chart report as an expression. For example, let's assume that you have deployed your report to a SharePoint document library available at http://my_sharepoint_site/reports_document_library/my_chart_report.rdl (you also see this URL in BIDS when you right click a report and say deploy - the output window in BIDS actually shows the URL to where the report got deployed to) and then if your Report Server in SharePoint integrated mode is available at http://my_sharepoint_server/ReportServer (this is the URL you would have configured under your report project properties in BIDS), your final URL would then be: http://my_sharepoint_server/ReportServer?http://my_sharepoint_site/reports_document_library/my_chart_report.rdl&rs:Command=Render&rs:Format=HTML4.0&rc:ClearSession=True&pTimeFiscalPeriod=ParameterValue With the above URL, you should now be able to clear the session each time you click on your chart's series. ALso, we pass the parameter values through the URL itself using the GET method.. For more information on URL access, you can also refer to the MSDN article below: http://msdn.microsoft.com/en-us/library/ms153586.aspx Can you please do the above steps and let me know if this helps? HTH. Cheers, IceQB Please mark correct answers :)

Hi Mathew, Have you tried IceQBs suggestion? I marked his post as answer, if this answer is not correct, please unmarked it. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Hi Mathew, Have you tried IceQBs suggestion? I marked his post as answer, if this answer is not correct, please unmarked it. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Hi Mathew, Have you tried IceQBs suggestion? I marked his post as answer, if this answer is not correct, please unmarked it. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Hi Charlie, I haven't tried IceQB's suggestion yet, so have unmarked it as the answer. We use relatively complex logic when passing the parameters, so including them in the URL is going to be problematic. I still want to explore the possibility that this is a PerformancePoint Services issue. Regards, Mathew.