The following topics supplement the multidimensional expressions (MDX) syntax documented in the OLE DB for OLAP extensions to OLE DB, which are not repeated here. It contains Backus-Naur Form (BNF) definitions and information about the additional data definition language (DDL) statements implemented by PivotTable® Service. These statements support the MDX syntax.
| Statement | Description |
|---|---|
| CREATE CACHE | Defines cache on the session level. |
| CREATE CUBE | Defines the logical structure of a local cube. |
| CREATE MEMBER | Defines a calculated member on the session level. |
| CREATE SET | Defines a user-defined set on the session level. |
| DROP MEMBER | Deletes a calculated member. |
| DROP SET | Deletes a user-defined set. |
| REFRESH CUBE | Rereads the data that formed the local cube. |