Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: Building a PivotTable List within FrontPage
Continuing the Lesson
The first half of this tutorial presented an introduction to using Office PivotTable lists to retrieve and display information from an OLAP cube. We focused on creating a PivotTable list from an Excel PivotTable report, learning the steps to define the data source, establish a connection to the cube, and set up a PivotTable report to serve as a basis for the PivotTable list. We also published an existing Excel PivotTable report as a web page to create a PivotTable list. Finally, we discussed similarities and differences between the Excel PivotTable report and the Office PivotTable list, focusing on navigation and use of the PivotTable.
In this conclusion to the lesson, we'll continue our exploration of Office PivotTable lists, designing the reporting mechanism from the ground up by using Microsoft FrontPage as a design environment. Various options are 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.
This tutorial focuses on the second main approach to creating a PivotTable list, through a design mode environment, to accomplish the following objectives:
Explore additional facets of the basic use and navigation of the various components that comprise PivotTable list functionality, including Microsoft FrontPage 2000
Focus on designing a PivotTable list from the ground up, to provide flexibility in information delivery to meet business needs
Incorporate control over the capabilities afforded to the information consumer through design capabilities within FrontPage 2000
The first half of this tutorial approached the creation of a PivotTable list from the perspective of a PivotTable report. We started by creating a PivotTable report, complete with data source setup, and transformed it into a PivotTable list that we used as a vehicle for learning the general features of the list. In this part of the lesson, we'll explore the design and creation of a PivotTable list "from scratch," discussing the differences in the two methods of development, and highlighting the strengths of designing the PivotTable list in the web-based environment for which it was originally designed.