7.5. Scorecard Design and Configuration

In PerformancePoint, scorecards can also contain dimensional data elements that provide a hierarchical breakout of the KPIs, which are in turn based on hierarchical data elements in a cube. Figure 7-21 shows an already existing scorecard, and to demonstrate this Dimensional model, portrays the "Pivot" capability that is inherently available with such a design.

  1. Click the Sales Scorecard in the left-pane Workspace Browser tree list.

  2. Click the Pivot icon in the Scorecard Editor menu group, on the Design tab of the Ribbon menu.

Figure 7-21 shows a nice aspect of a dimensional scorecard: the ability to completely pivot the data (swap rows with columns). Notice that the Details tree-view pane on the right side ...

Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.