Applies to:
- Microsoft® Excel 2002
- Microsoft SQL Server™ 2000 Analysis Services
Microsoft® Excel provides you with the ability to use Microsoft PivotTables® to summarize data stored in online analytical processing (OLAP) cubes. This article describes how you can extend Excel OLAP functionality to obtain detailed records for an aggregate value, update an OLAP cube with a new aggregate, and retrieve one or more aggregates from an OLAP cube into a worksheet without creating a PivotTable.
|