Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: OLAP Reporting with an Office PivotTable List
Next in This Series
In this tutorial, we ventured beyond using Excel PivotTable reports to retrieve and display information from an OLAP cube, and introduced the Office PivotTable list as an alternative means of integrating Office 2000 with Microsoft SQL Server 2000 Analysis Services. We explored basic navigation of the Office PivotTable list, and undertook creating a PivotTable list in the first of two main ways: publishing an existing Excel PivotTable report as a web page to create a PivotTable list.
We discussed many of the similarities and differences between the Excel PivotTable report and the Office PivotTable list, while focusing examples on designing a PivotTable list to provide flexibility in information delivery to meet business needs. Finally, we exposed various options available to the PivotTable list designer to control the capabilities afforded to the information consumer, specifically through placing restrictive setpoints in design mode, and enforcing those setpoints in the browser through which information consumers access the PivotTable list.
The next lesson, OLAP Reporting with an Office PivotTable List, Part 2," introduces the second main approach for creating an Office PivotTable list: designing and creating a PivotTable list from scratch by using the design environment of another Microsoft Office 2000 application, FrontPage 2000. We'll continue to compare the PivotTable list to the Excel PivotTable report, and will focus on the capabilities that are available when creating PivotTable lists within their web-ready native environment.