Microsoft® SQL Server™ OLAP Services version 7.0 includes the OLAP server and PivotTable Service. The OLAP server manages and stores multidimensional OLAP information and serves client application requests for OLAP data. PivotTable® Service is an OLE DB for OLAP provider that connects client applications to the OLAP server and manages offline cubes. A repository of metadata contains definitions of OLAP data objects such as cubes and their elements.
An object model, Decision Support Objects (DSO), provides support for the OLAP Manager user interface and for custom applications that manage OLAP metadata and control the server. An interface, IOlapAddIn, enables your applications to extend and interact with the user interface. PivotTable Service provides access to OLAP data from the server, and the ability to create local cubes.
This introduction section contains the following topics.
Topic | Contains |
---|---|
System Architecture | An overview of the building blocks of OLAP Services and PivotTable Service and how they all work together. |
Programming Environment | Information about the environments and interfaces to use when developing applications for OLAP Services and PivotTable Service. |
Component Tools | Descriptions and capabilities of the component tools you can use to build your applications. |