Thursday, June 23, 2011

Microsoft SQL Server Reporting Services vs PerformancePoint Services

These 2 products aren't often compared with each other, and they are in fact different. However there are times where their capabilities overlap and reasons for using one instead of the other may be unclear, especially when using these tools together with Analysis Services.

Since not much information on such aspects seem to be available on the internet, below is a basic list displaying some comparisons.


Product
Standardized reports
Dynamic dashboards
Audience
Few to many users
Power users
Usage
Operational and Management
Strategy and Management
Measures
Fixed
Changeable
Dimensions
Fixed
Changeable
Drilldown
Fixed drilldown or drill through path as defined in report
Flexible drilldown for any report
Styling
Customizable to the lowest detail
Fixed appearance
Distribution
Online, Email, File Share or Printed
Online
Export
CSV, Excel, Image, PDF, Word or XML
Excel, PowerPoint (Individual Dashboard Elements)
Security
At report level. Users see what the report displays
At data warehouse level. Users see all data they have access to

It is certainly possible to implement some tricks or workarounds in order to achieve some capabilities such as styling in PerformancePoint using CSS, but those were the general aspects of the two tools. It should give a good idea of the differences.