Connecting performance point filters to other web parts

I'd like to connect a perofrmance point filter to a reqular sharepoint web part- like a document library. For example, a location filter would link to a column in the library called 'Location', then filter the list.

On my dashboard, I've made connections to pass the filter value to the web part- it seems like it should be that simple. But, changing the filter doesn't refresh the web part.

Has anyone gotten this to work? I've seen a couple blogs that say its possible, but no one has examples.

Thanks.

John

After much head banging, and finally a support case with Microsoft, I have learned that this is an issue created by SP1. It breaks the functionality. Microsoft knows about the bug, and tells me that a fix may be available in February 2012.

It's a huge pain. Encountered it first training some students.

GRRRR ARRRGHH!!!! Regression testing anyone?

Anyway, do you have references for the fix in Feb 2012?

Mark,

I don't have anything official other than what I was told during the support case. I will update this thread once we have applied the CU and can confirm the fix.

We have installed the latest CU (February 2012?) and the behavior is fixed.

Hi JMBaute

Our testing with feb 2012 CU indicates that it is *not* fixed, and we built our own code to workaround it.

Indeed , looking at Feb2012 CU list of fixes, it's not listed :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2597150

Two PPS hotfixes included, but no mention of the document library issue

http://support.microsoft.com/kb/2598025 

The second fix does mention filters, but calls out RS specifically.

http://support.microsoft.com/kb/2597936

What types of web part are you connecting to?

Mark,

Like you, we ended up writing our own code as a workaround. In retrospect I don't recall if I tested the filter against a SSRS report or against the document library. So, I could be mistaken if this CU actually fixed the glitch. Sorry if my response was misleading.

John

Ahhh cool.

Out of interest, what did you do for your code?

We built a webpart that receives PPS Connections, and outputs Filter and Parameter connections - to make it as generic as we can and reusable.

Going to publish it in the next week or two to let others make use of it.

Well, I wasn't the one to write the work around, but I'll try to explain what they did:

We built a custom web control for our "filter", basically a hierarchical list of locations. Then, based on this selection, the Sharepoint page we wanted was then opened with the user selection passed into the query string of the page. Probably not super secure since a user could edit the URL if he was so inclined...

If you don't mind, update this thread when you publish your code? It might help us!

thanks,

John

Here we go:

http://ppsfilters2010.codeplex.com/

Code to make this connection work - generically