Client Architecture
PivotTable® Service communicates with the Analysis server and provides interfaces that client applications can use to access OLAP data and data mining 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. That is, to query local cubes, a connection to the Analysis server is not required; connection to the local cubes' data sources is not required if the local cubes have a multidimensional OLAP (MOLAP) storage mode.
PivotTable Service can also create local data mining model files that contain models processed from cubes or tables on the server or from OLE DB relational databases. Local data mining models can be stored on the client computer. Local data mining models can be used offline with PivotTable Service for portable analysis. That is, to use local data mining models, a connection to the Analysis server is not required.
For more information about programming the client, see PivotTable Service.