Building an OLAP Database

Please keep in mind that the primary audience of this book is the database administrator and, as such, the focus of the chapter will be on the administrative activities required to support an OLAP database. The following discussion on creating the OLAP database, cubes, dimensions, levels, and so on is provided only to give you a basic understanding of the concepts behind the development of a multidimensional database using Analysis Services. This discussion is by no means a complete discussion of the many complexities surrounding the design and development of OLAP databases. Entire books are devoted to this subject, including Microsoft Analysis Services Unleashed from Sams. I would encourage you to read one of those ...

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

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