PerformancePoint Services 2010 Analytical Grid Filter Fix, Sort of
Posted by denglishbi on December 23, 2010
Back in September there was a forum posting that was looking for a solution to resolving the filtering issue with Analytical Grids in PerformancePoint – filter value function not working on analytic grid. The filtering functionality was working fine with Analytical Charts, but for Grids there seemed to be a slight bug. When the Top filter was applied to an Analytical Grid report you would received messages like the following:
There is no data to display.
Drag measures, dimensions, or named sets to Rows and Columns to lay out the report.
there are no data rows to display
So what was going on, because if you switched the Report Type from Grid to say Bar Chart it worked just fine…
If you set this up in a Chart and then flipped back to Grid then it would retain the setting. If you modified the filter at this point then you would get what you see in the first screenshot above.
Well just this month a new Cumulative Update was released for SQL Server 2008 R2 – Cumulative Update 5. It just so happens that one of the fixes in this was related to PerformancePoint Services!
I typically wait until a Service Pack is released, but I always review the fixes that are included in the Cumulative Updates, because you just never know when you might uncover an item that could resolve an issue that you have been having or might not have been aware of.
In order to get this fix you need to request the hotfix from the main page – Cumulative Update package 5 for SQL Server 2008 R2. Once you do this you will get an email with the download link and also a password to unzip the actual hotfix package that you can install.
Here are some screenshots of the installation process which took approximately 10 minutes to install on my machine:
Once you get this installed you will be on SQL Server 2008 R2 version number 10.50.1753.0. After I performed the install it did require a reboot in my situation.
Now we go back and test out our filter functionality on the Analytical Grid and the results are…
Well we didn’t get an error like the one in the first screenshot, but it doesn’t apply the filter properly like it does if we switch over to an Analytical Chart:
It appears that they fixed part of the issue, but it is still not handling the user defined hierarchy filtering. If we use just a attribute hierarchy then it works just fine.
So at this point it will take a little more investigation and a follow-up reply to the original forum posting.