MDX Data Manipulation Statements (MDX)


Updated: March 2, 2016

In Multidimensional Expressions (MDX), data manipulation statements retrieve and manipulate data from multidimensional objects. The following table lists the data manipulation statements in MDX.

CALL Statement (MDX)Runs a stored procedure that returns a void either in the current scope or optionally on a specified cube.
CLEAR CALCULATIONS Statement (MDX)Removes all calculations from the cube and returns the cube to calculation pass 0.
DRILLTHROUGH Statement (MDX)Retrieves the rowsets that were used to create a specified cell in a cube.
SELECT Statement (MDX)Retrieves data from a specified cube.
UPDATE CUBE Statement (MDX)Updates the value of a specified leaf or nonleaf cell in a cube, optionally allocating the value for a specified non-leaf cell across dependent leaf cells.

MDX Statement Reference (MDX)
MDX Data Definition Statements (MDX)
MDX Scripting Statements (MDX)

Community Additions