Joe Hayes  (josehay@microsoft.com)

Microsoft Corporation

February 2008

Applies to:
Microsoft Office PerformancePoint Server 2007


Summary: This article contains a custom dashboard filter plug-in for Microsoft Office PerformancePoint Server 2007.

Sample Code File SQLQueryParameterSample

Introduction

You can create a custom dashboard filter plug-in for Microsoft Office PerformancePoint Server 2007. Filters let dashboard users refine the data that displays in scorecards and reports in a PerformancePoint Server dashboard. The custom filter sample in this article adds a "SQL Query" filter that works with ODBC data sources. The filter is populated with the results of a SQL statement or stored procedure.

The sample implements a custom filter data provider and wizard pages for building the filter. The data provider assumes that column 1 of the SQL result set is the key and column 2 is the display name. If there is only 1 column in the result set it is used for both key and display name.

Note: This sample filter does not contain a web control or implement filter persistence.

Instructions for Use

Prerequisite: PerformancePoint Monitoring Server and Visual Studio must be installed.

1. Unzip the file.

2. Follow the instructions in the INSTALL.txt file in the code sample.

3. Open ODBCSampleComplete.bswx and click Publish All on the Home tab.

6. Browse to your new dashboard on the web. When you change the filter, the data on the dashboard updates.

7. Now that you've built this sample from code and deployed it, use it as a model to create your own custom filters.

Conclusion

You can use the code sample as a model to create your own custom filters for Microsoft Office PerformancePoint Server 2007. For additional documentation surrounding this sample, see the "Dashboard Filters" section in the PerformancePoint Monitoring SDK on MSDN: http://msdn2.microsoft.com/en-us/library/bb836266.aspx