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.

TopicDescription
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

ADD
Show: