Chapter 10

SQL Server Analysis Services

Solutions in this chapter:

 Overview of OLAP and Data Mining

 New Features in Analysis Services

 The Analysis Services Architecture

 Installing Analysis Services

 Designing and Building an OLAP Solution

 Designing and Building Cubes

 Defining Measures and Dimensions

 Using Your OLAP Solution

 Data Mining in SQL Server

 Security in Analysis Services

 Accessing Analysis Services Over the Web

 Performance Tuning and Optimization

Introduction

Analyzing and understanding your data are the roles of SQL Server 2000’s enhanced OLAP and new data-mining components. Renamed Analysis Services in SQL Server 2000, online analytical processing (OLAP) services have been enhanced to provide greater capability and scalability. ...

Get Designing SQL Server 2000 Databases 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.