Chapter 2. Administering SQL Server 2005 Analysis Services

Analysis Services is a SQL Server 2005 component that provides a foundation for business intelligence (BI) applications through online analytical processing (OLAP) and data mining functionality.

This chapter outlines the tasks associated with administering and managing an Analysis Services implementation. It starts with an overview of Analysis Services, which includes terminology, architecture, and a review of the different versions. In addition, this chapter highlights what is new with Service Pack 2. The chapter also includes step-by-step tasks for Analysis Services administration and management, such as processing cubes, using storage modes, monitoring performance, and creating backups ...

Get Microsoft now with O’Reilly online learning.

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