Creating an Excel PivotTable Report

PivotTable reports have been a feature of Microsoft Excel since version 5. Traditionally, a PivotTable report has used a memory-cache method to provide values to the report. In this method, the PivotTable imports values from an Excel list or a database table and stores the values in memory. When a user manipulates the PivotTable report, the report retrieves necessary values from the memory cache. PivotTable reports have been an extremely popular and successful feature of Excel, but the memory-cache method for retrieving values can manipulate only a limited amount of data.

With Office 2000, Excel offers a second method for providing values to a PivotTable report: an OLAP cube. Using an OLAP cube, a PivotTable ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.