The Programmer's Reference contains reference pages necessary for working with PivotTable® Service. The following table describes the information contained in each set of reference topics.
| Topic | Description |
|---|---|
| PivotTable Service Properties | Description of properties that can be set in the connection |
| Data Definition Language | Statements for defining a local cube, creating a local cube, and altering the structure of a server cube |
| Data Manipulation Language | Information about data manipulation commands, such as the SELECT and INSERT_INTO statements |
| Function Reference | Details about available OLAP and data mining functions |
| Schema Rowsets | Additions to the schema rowsets defined by the OLAP portion of the OLE DB specification and new schema rowset restriction columns |