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