Following are the difference between SQL Server Reporting Services (SSRS)
and Performance Point Server (PPS)
- SSRS as
well as PPS both has sufficient set of Indicators that required for any
report including Scorecard & Dashboard.
- Report
Performance will be good if we go with SSRS if application DB & Report
server DB will be in same SQL Server instance. For SharePoint, we need to
configure Business data connectivity services in the SharePoint that won’t
be faster that SSRS instance.
- PPS will
be preferable if we have to show dynamic reports e.g we can change a
tabular report to Chart etc on report itself. SSRS is good for canned reports.
- Following
are the few formatting issue with PPS 2007:
- Cannot do custom labelling.
- Cannot increase custom width
- Cannot get grand totals
- Cannot get subtotals
- Adding
KPIs in SSRS is easier as compare to PPS.
- In PPS,
colors/fonts in data cells cannot be changed. But in SSRS, each cell can
be altered in terms of colors and number formats.
- SSRS
report will take 2-5 mins or more to generate the report if it has bulk
data.
- In SSRS,
each sub-report (popup report) will be a separate report (rdl) that will
reference the main report.
- In SSRS,
Drilldown will be slightly slow if we have bulk data on report compared to
PPS
- Maintenance
of SSRS instance is easier than maintaining SharePoint Server.
- By using
Caching & Report Snapshot, we can achieve a good performance in SSRS.
No comments:
Post a Comment