Home > Articles > Data > SQL Server

Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office: OLAP Reporting with an Office PivotTable List

Build reports with an Office PivotTable list as a flexible alternative to PivotTable Reports. In this tutorial, we build a PivotTable list based on an existing Excel PivotTable report, and compare some of its characteristics to those of its PivotTable report counterpart. Our focus is the selection of an OLAP cube as the primary data source.
Like this article? We recommend

About the Series

This is the first of a two-part tutorial article within a series, "Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office," that introduces numerous features in the partnership of Microsoft SQL Server 2000 Analysis Services and Office 2000 (and beyond). As discussed in the first article in this series, "Creating an Excel PivotTable Report with an OLAP Cube," we'll explore features that serve to integrate the applications, providing enhanced business intelligence capabilities.

For more information on the series, as well as the hardware/software requirements to prepare for the tutorials we'll undertake, see the first article in the series, "Creating an Excel PivotTable Report with an OLAP Cube."

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.