UPDATE (6/21/2011): Modified table layout of step-by-step walkthrough to be two columns instead of three. Added a downloaded PDF file as well.
Back in January I did a posting in regards to Using Excel Services Reports with PerformancePoint Server (PPS). This has been a very popular posting and I thought I would add another one in regards to using Reporting Services (SSRS) reports with PerformancePoint (in PPS 2007 this type of report was called SQL Server Report).
Some of the reason that you might want to include a SSRS report in your PPS dashboard would be because:
- leverage an existing report created by an end-user
- incorporate existing operational reports
- use additional charting options – map, area, range, scatter, polar, bar (not column), funnel, 3D, sparklines, data bars
- need more flexibility and control over reports, styles, colors, scales, etc.
- join multiple data sources into a single report
- combine relational and OLAP data into a single report
The example that I will be showing is using SSRS in SharePoint Integrated Mode, but you can also do this in Native Mode as well, you would just see a different setup screen when you are configuring the report in Dashboard Designer (a tad bit easier in my opinion configuring these in Native Mode – which is labeled as ‘Report Center’ mode in Dashboard Designer, confusing I know…). I will also be using Report Builder 3.0 to create and deploy the report to the SharePoint site.
My example here used the Contoso Retail DW sample data which is available from the Microsoft downloads here – Microsoft Contoso BI Demo Dataset for Retail Industry. This is also using Reporting Services 2008 R2 which includes the new Map report item, Report Builder 3.0, PerformancePoint Services, and SharePoint 2010 Enterprise.
I have two other postings that I did earlier in the year in regards to the new Map report item here that you can check out if you have questions in regards to that:
Feel free to download the PPS Workspace file (ddwx) and the SSRS report (RDL) file from my SkyDrive which I have included in a zip file.
You might find this posting useful if you want to reuse the workspace file – Migrating PerformancePoint 2010 Content to New Server.
Enjoy and Happy New Year!