Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

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

image

So what was going on, because if you switched the Report Type from Grid to say Bar Chart it worked just fine…

image

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! 

FIX: An analytic grid that is connected to SSAS 2008 R2 returns incorrect data when you apply a filter to the analytic grid in PerformancePoint Dashboard Designer

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:

image image
image image
image image
image image
image image

 

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…

image

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:

image

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.

image

So at this point it will take a little more investigation and a follow-up reply to the original forum posting.

Advertisements

2 Responses to “PerformancePoint Services 2010 Analytical Grid Filter Fix, Sort of”

  1. […] version of PerformancePoint.  I know that there was a fix added in SQL Server 2008 R2 CU5, PerformancePoint Services 2010 Analytical Grid Filter Fix, Sort of, but I was wondering if there was anything else.  Well it turns out there has been.  So […]

  2. […] Some quick research revealed that the problem is with the generation of the MDX (Query) when working with the Analytic Grid and how SQL 2008 R2 handles it. You can request a hotfix for the problem (for SQL 2008 R2), but it apparently doesn’t fully fix the problem. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: