Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: OLAP Reporting with an Office PivotTable List
Lesson 1 of this series presented an introduction to using Excel PivotTable reports to retrieve and display information from an OLAP cube. We discussed the steps needed to define our data source, and to establish a connection to the cube. After exposing the layout of the PivotTable report, we explored the use of the PivotTable toolbar in browsing and reporting on cube data. Finally, we discussed the intersection of dimensions in the PivotTable report axes as a means of making reports truly multidimensional.
In this tutorial, we venture beyond the topics introduced in Part 1, to accomplish the following objectives:
Introduce the Office PivotTable list, and explore many of its capabilities as another means of integrating Microsoft Office with an OLAP cube
Explore the basic use and navigation of the various components that comprise PivotTable list functionality
Discuss similarities and differences between the PivotTable report and the PivotTable list
Build an Office PivotTable list from an existing Excel PivotTable report