Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: OLAP Reporting with an Office PivotTable List
- About the Series
- Introducing the Office PivotTable List
- Publishing an Excel PivotTable Report as an Office PivotTable List
- Next in This Series
Introducing the Office PivotTable List
An Office PivotTable list can link to an Analysis Services cube, just like the Excel PivotTable report we constructed and manipulated in Part 1 of this series. While the general behavior is somewhat similar with the PivotTable list, the fact that the PivotTable list evolved after the PivotTable report, and was designed specifically for use with OLAP cubes, make the PivotTable list more adapted to the multidimensional data source, and more flexible in reporting from it, in most respects. We'll touch on a few of the differences in the two tools as we progress through this lesson, and highlight the strengths and weaknesses of the PivotTable list to help select the best tool for our needs, or to meet the needs of the information consumers we support.
We'll approach the creation of a PivotTable list first from the perspective of the PivotTable report. In Part 1 (this article), we'll start with a PivotTable report, and transform it into a PivotTable list that we'll use as a vehicle for learning its features. In Part 2, we'll explore the design and creation of a PivotTable list "from scratch," discussing the differences in the two methods of development.