Database Reference
In-Depth Information
This cross-filtering works only from a PerformancePoint scorecard, not the
analytic chart. It can, however, be used to filter an analytic chart by a scorecard.
ExCEL PIVoT TABLES
Excel pivot charts are by far the most widely known of the slice and dice tools,
and they have a flexibility that none of the other Microsoft tools do. Excel
pivots can be created against any data contained within Excel, but they do
work much better when they have a solid data model to work from.
The pivot tables can be built up manually, but it is a lot more work because
each level has to be added individually, and the subtotals removed. An example
of such a pivot is shown in Figure 13-12.
There are other benefits to putting the data into a model first: centrally con-
trolling the structure is the first benefit, the additional calculation power of
DAX becomes available, and the data volumes that can be handled increase
exponentially. The improved interface is shown in Figure 13-13.
Finally, when Excel pivots are deployed to Excel Services in SharePoint, they
can be connected to PerformancePoint scorecards—the scorecard row values
connect up to the slicers and change their values.
F I g u R e 13 -12
Editing a pivot table
F I g u R e 13-13
The Pivot-
Table Fields task pane, where
fields are added to the table
