Home > Articles > Data > SQL Server

Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office, Part 1: Creating an Excel PivotTable Report with an OLAP Cube

  • Print
  • + Share This
Explore the analysis capabilities of the Excel PivotTable report to present data from an OLAP (OnLine Analytical Processing) cube. In this tutorial, learn how to build a PivotTable report from scratch, and explore the details of its cube-focused functionality.
Like this article? We recommend

Introduction to the Series

This is the first tutorial of a new series, Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office, that will introduce the new user to some of the features in the MSSQL Server 2000 Analysis Services / Office 2000 (and beyond) partnership. We'll explore features that serve to integrate the applications, providing enhanced client reporting and other business intelligence capabilities. The central focus of the series will initially be the analysis capabilities of Microsoft Excel, including the PivotTable functionality and its roles as the client representative of the Analysis Server, as a communicator with stand-alone local cubes, and as creator and user of local cubes.

We'll explore the following topics within this series:

  • PivotTable reporting features that are available with Microsoft Excel 2000, and PivotTable options that provide for creating robust and flexible reports

  • Office PivotTable List capabilities that allow another means of integration with the OLAP cube

  • The basics of use and navigation of the components that comprise PivotTable list reporting functionality, including Microsoft FrontPage

The creation of a local cube with Office 2000, from either a PivotTable report or a relational data source

In this session, we'll explore the analysis capabilities of the Excel PivotTable report in presenting OLAP data to consumers. Among the topics we'll cover in this hands-on tutorial are the following:

  • Setting up a connection between an OLAP cube and a PivotTable report

  • General navigation of member information

  • Drilling down to details of reporting summaries

  • Venturing beyond the "X-Y" dimensions to make the PivotTable report truly multidimensional

General formatting options for the PivotTable report

  • + Share This
  • 🔖 Save To Your Account