Understanding Analysis Services

As mentioned earlier, a data warehouse is a “place for people to access their data.” Without Analysis Services, a data warehouse reporting system consists of a relational database at one end that stores data values, and a reporting application at the other end that displays those values. Analysis Services fits between the relational database and the reporting application. It functions as an intermediate layer that converts relational warehouse data into a form that makes it fast and flexible for creating analytical reports.

The primary component of Analysis Services is the Analysis server. Running as a service on Microsoft Windows 2000 or Microsoft Windows NT, the Analysis server extracts information from the ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

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