Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office, Part 1: Creating an Excel PivotTable Report with an OLAP Cube
- Sep 20, 2002
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
