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 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.