Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: Building a PivotTable List within FrontPage
Next in This Series
In this two-part 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 two main ways: In the first part of the lesson, we published an existing Excel PivotTable report as a web page to create a PivotTable list. In this part of the lesson, we designed and created a PivotTable list from scratch, using the design environment of another Microsoft Office 2000 application, FrontPage 2000.
Throughout the lesson, 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.
Our next lesson, "Creating a Local Cube with Office 2000," introduces the creation and use of local cubes with Office 2000. Similar to the approach we've taken in the first two lessons of this series, we'll overview the concepts of the topic, and then delve into the practical aspects involved in putting the functionality to work immediately. Also similar to our previous approach, we'll use the PivotTable fundamentals we've practiced thus far to develop new ways to deliver information with Office 2000 components: We'll create a local cube from an existing Excel PivotTable report, and then explore a more design-oriented route, through the use of the OLAP Cube Wizard, to accomplish cube creation in a more flexible manner.