PivotTable® Service communicates with the OLAP server and provides interfaces for use by client applications accessing OLAP data on the server. Client applications connect to PivotTable Service using OLE DB interfaces for C++ or the Microsoft® ActiveX® Data Objects (ADO) object model for Component Object Model (COM) automation languages such as Microsoft Visual Basic®.
PivotTable Service can also create local cube files that contain data from a cube on the server or from OLE DB relational databases. Local cubes can be stored as multidimensional cube files on the client computer. Local cubes can be used offline with PivotTable Service for portable analysis.
For more information about programming the client, see PivotTable Service.