Part I: The New OLAP Paradigm-MS OLAP Services in SQL Server 7.0
1 Microsoft's Entry into the World of OLAP
2 How OLAP Is Used in the Real World
3 The Keys to a Successful OLAP System

Part II: Preparing Data for OLAP
4 Enterprise Data Structure and Data Flow
5 The Star Schema
6 MS Data Transformation Services (DTS)
7 The Core Data Transformation Tasks
8 Using Other DTS Tasks
9 DTS Packages
10 Using the DTS Import and Export Wizards
11 Writing ActiveX Scripts
12 Programming with the DTS Object Model
13 Using the Repository in Data Transformations
14 Third-Party Data Transformation and Repository Tools

Part III: Creating OLAP Cubes
15 Creating Cubes
16 Processing and Browsing Cubes
17 Partitioning Cubes and Administering OLAP Server

Part IV: Programming the OLAP Server
18 Decision Support Objects
19 Developing an Add-In Program for OLAP Services
20 The PivotTable Service
21 Other OLE DB for OLAP Servers

Part V: Programming the OLAP Client
22 Programming Access to the OLAP Data Sources
23 Implementing Microsoft Excel as an OLAP Client
24 Building an OLAP Web Client
25 Building an OLAP Client Application with Visual Basic
26 Third-Party OLAP Clients

Part VI: Querying with Multidimensional Expressions (MDX)
27 Building an MDX Query
28 Advanced MDX Queries
29 Using SQL Queries on OLAP Services
30 MDX Reference

Part VII: Managing a Data Warehousing System
31 Performance Issues
32 Indexing
33 OLAP Security
34 Metadata

sdg