Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MDX Data Manipulation Statements (MDX)

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

Topic

Description

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 (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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.