PerformancePoint Server KPIs and Office SharePoint Server KPIs
Last month I wrote a post, PerformancePoint Server OR SharePoint BI, that addresses some confusion that many have had about differences between BI features in Office SharePoint Server and PerformancePoint Server (PPS). Today, I provide more detail about existing features, such as KPIs, scorecards, indicators, and dashboards, found in both platforms.
Some things to remember.
- PerformancePoint Server is not SharePoint shrink-wrapped in a BI toolset. PPS uses MOSS or WSS as part of the platform to deliver complete business intelligence and performance management applications for the person, team, and enterprise.
- Office SharePoint Server provides self-service BI where PerformancePoint Server offers more organizational or enterprise level BI. As personal BI is shared with team members, the ability to share insights and information can transform into organizational BI so that strategic application can be monitored.
The following compares between the monitoring features for scorecards, dashboards, KPIs, and indicators.
[disclaimer] Admittedly, most of my writing is for the IT Pro for PPS architecture, deployment, and operations.
KPIs
| Feature | MOSS BI today | PPS M&A |
| Objectives Rollup | | X |
| Objective values (Sum, Min) | | X |
| Normalized Scoring | | X |
| KPI Weights | | X |
| Analysis Services Measures | | X |
| Analysis Services KPI’s | X | X |
| Data Sources per KPI | Single | Multiple |
| Formatting | | X |
| Band by Normalized Values | | X |
| Band by Numeric Values | X | X |
| Thresholds | 3 | unlimited |
| Multiple Targets | | X |
| Dimension filters on Column | X | X |
| Dimension filters on Row | | X |
| MDX Filters | | X |
| Time Intelligence filters | | X |
Scorecards
| Features | MOSS BI today | PPS M&A |
| Scorecard Object | | X |
| Objective Icons | | X |
| Objective Values Rollup (Min,Max,Sum) | | X |
| Nested Objectives | | X |
| Trend Arrows | | X |
| Interactivity | | X |
| Annotations | | X |
| Normalized Scoring Values | | X |
| Time Intelligence | | X |
| Scorecard Customization | | X |
| Column Aggregation (Sum,Avg,Min,Max) | | X |
| Dimension slicers on the row | | X |
| Dimension slicers on Column | | X |
| Properties | | X |
| Named sets | | X |
| Custom Formulas | | X |
| Scorecard Interactivity | | X |
| Cell comments | | X |
| Indicator count roll Ups | | X |
| Sort and filter | | X |
| Expand/Collapse | | X |
Indicators
| Features | MOSS BI today | PPS M&A |
| Library of Indicator Visualizations | | Numerous |
| Thresholds | 3 | |
| Centered Indicators | | X |
| Customization | | X |
| Formatted Properties | | X |
Dashboards
| Features | MOSS BI today | PPS M&A |
| Templates | 3 | X |
| Filter on Columns | | X |
| Filter on Page | X | X |
| Filters on Rows | | X |
| Time Intelligence | | X |
| MDX Filters | | X |
| Named Set Filters | | X |
| Post Formula | | X |
| Display Condition Filters | | X |
| Multi-Page Dashboards | | X |
| Sticky Parameter | | X |
