Analysis Services Programming
Data Manipulation Language
The following topics describe the data manipulation language (DML) used by PivotTable® Service.
| Topic | Description |
|---|---|
| DRILLTHROUGH Statement | Retrieves the source rowset(s) from the fact table (that is, data source) for a specified |
| INSERT INTO Statement | Describes the INSERT INTO statement, which populates a local cube with dimension members. |
| SELECT Statement | Describes the SELECT statement, which is used to create queries that return multidimensional data, either in a Microsoft® ActiveX® Data Objects (ADO) Cellset object or in an OLE DB Dataset object. |
| UPDATE CUBE Statement | Describes the UPDATE CUBE statement, which allocates values from a nonleaf member cell update to all of the children of that member. |