Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Creating an Office PivotTable List

An Office PivotTable list is superficially similar to an Excel PivotTable report. Both tools can link to an Analysis Services cube. Both tools can use a member to filter, and both tools allow you to show and hide levels of a dimension on an axis. But the tools behave differently in many ways. With an Excel PivotTable report, the ability to communicate with an OLAP cube was added to an existing feature, and the user interface sometimes seems more closely adapted to the old features than to the new ones. The interface for an Office PivotTable list was created with OLAP cubes in mind, so the PivotTable list is often a more flexible tool for working with an OLAP cube.

Create a PivotTable List from a PivotTable ...