Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Chapter 5. Office 2000 Analysis Components

Chapter Objectives Estimated time: 1.75 hours
In this chapter, you’ll learn about the different components that share the PivotTable name and how to
Create and manipulate a Microsoft Excel PivotTable report based on an OLAP cube. Create and use an Excel PivotChart report based on an OLAP cube. Create and manipulate a Microsoft Office PivotTable list for use in a Web page. Use Microsoft FrontPage to design an Office PivotTable list. Derive a local cube from an existing PivotTable report. Create a local cube directly from a relational data source.

Dr. Seuss once wrote a story about a mother who had 23 sons and named them all Dave. Even if you haven’t read the story, you can imagine the chaos that ensued. Unfortunately, ...