Filtering the values based on Custom Value from Connectible WebPart to Performance Point Filter
SharePoint 2010 Provided Performance Point Filters With Service Pack1 does not have the Option of Filtering The values based on Custom Web Part value passed using Connectible Provider. We have also tried using IBITransformableProvider Interface.
Solution: Use the ITransformableFilterValues Interface.
Custom WebPart passes Project Number. Performance Point Services Filter Does not Filter the values based on the Custom Web Part Value. We are not able to get the phases for the Selected Project from Custom Web Part. Tried Lot of Options. Nothing worked out.
We have also tried using ITransformableBIDataProvider Interface. But Nothing worked and Microsoft has not provided sufficient Information on ITransformableBIDataProvider.
public class MoldKPIChart : Microsoft.SharePoint.WebPartPages.WebPart
{
protected ITransformableBIDataProvider filterProvider;
[ConnectionConsumer("Filter Value", "FilterConsumer", AllowsMultipleConnections = true)]
public void FilterValuesConsumer(ITransformableBIDataProvider Provider)
{
filterProvider = Provider;
}
}
Solution:-
Developed Custom Connectible WebParts for Provider as well as Consumer to Achieve the required functionality.
We have used ITransformableFilterValues to achieve Multiple Selected Values.
With ITransformableFilterValues, We can pass MultipleValues to Consumer WebPart. ConsumerWebPart in our case was PerformancePoint 2010 Grid/Charts. This became a Tedious Task for us.