Microsoft PivotTable Service MDX Reference

This section supplements MDX syntax defined by OLE DB for OLAP Design Specification, which are not repeated herein, and contains the reference and Backus Normal Form (BNF) for the additional MDX statements implemented by Microsoft^® PivotTable^® Service:

• CREATE CUBE – Define the logical structure of a cube
  
  
• DROP CUBE – Delete an existing cube
  
  
• REFRESH CUBE – Re-read the data that formed the cube
  
  
• INSERT INTO – Bind the cube to a data source and populate the cube with data.
  
  
• CREATE MEMBER – Define a calculated member on the session level
  
  
• DROP MEMBER – Delete a calculated member
  
  
• ALTER MEMBER – Change the definition of a calculated member