Server and Client Architecture

Rapid access to data warehouse data is provided by Microsoft® SQL Server™ 2000 Analysis Services. Data from the data warehouse is extracted, summarized, organized, and stored in multidimensional structures for rapid response to end user queries.

Analysis Services also provides an architecture for access to data mining data. This data can be sent to the client in either a multidimensional or relational form.

Analysis Services and PivotTable® Service provide the capability to design, create, and manage cubes and data mining models from data warehouses and to provide client access to OLAP data and data mining data. The Analysis server manages the data; PivotTable Service works with the server to provide client access to the data.