| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
MDX Data Definition Statements (MDX) |
MDX Data Definition Statements (MDX) |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
In Multidimensional Expressions (MDX), data definition statements create, drop, and manipulate multidimensional objects. The following table lists the available data definition statements.
| Topic | Description |
|---|---|
| ALTER CUBE Statement (MDX) | Alters the structure of a specified cube. |
| CREATE ACTION Statement (MDX) | Creates an action that can be associated with a cube, dimension, hierarchy, or subordinate object. |
| CREATE CELL CALCULATION Statement (MDX) | Creates a calculation that evaluates an MDX expression over a specified set of tuples within a cube. |
| CREATE GLOBAL CUBE Statement (MDX) | Creates and populates a locally persisted cube, based on a subcube from a cube on the server. A connection to the server is not required to connect to the locally persisted cube. |
| CREATE MEMBER Statement (MDX) | Creates a calculated member. |
| CREATE SESSION CUBE Statement (MDX) | Creates and populates a cube available to all queries in the same the session, based on cubes on the server. |
| CREATE SET Statement (MDX) | Creates a named set for a specified cube. |
| CREATE SUBCUBE Statement (MDX) | Redefines the cube space of a specified cube or subcube to a specified subcube. |
| DROP ACTION Statement (MDX) | Deletes a specified action from a specified cube. |
| DROP CELL CALCULATION Statement (MDX) | Removes the specified cell calculation. |
| DROP MEMBER Statement (MDX) | Removes a calculated member. |
| DROP SET Statement (MDX) | Removes a named set. |
| DROP SUBCUBE Statement (MDX) | Drops a specified subcube, reverting to the previously defined cube or subcube definition with the specified name. |
| REFRESH CUBE Statement (MDX) | Refreshes the client cache for a cube. |
MDX Statement Reference (MDX)
MDX Data Manipulation Statements (MDX)
MDX Scripting Statements (MDX)