Chapter 31. SQL 2000 Analysis Services

By Kevin Viers

IN THIS CHAPTER

  • What Is OLAP?

  • Understanding Multidimensional Data

  • The Microsoft Analysis Manager

  • Building an OLAP Database

  • Data Storage in an OLAP Database

  • Optimizing an OLAP Database

  • Managing Multidimensional Data

  • Microsoft SQL Server 2000 Analysis Services FAQ

Microsoft Analysis Services is the Online Analytical Processing (OLAP) database engine that Microsoft ships with SQL Server 2000. Although the name is different, it is the upgrade to the OLAP Services that shipped with SQL Server 2000. Analysis Services is a feature-rich product in its own right, with the ability to interact with virtually any relational data store. It would be possible to dedicate an entire book to this product, but because ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.