mdx-data-manipulation-statements-mdx.md

title	MDX Data Manipulation Statements (MDX) | Microsoft Docs
ms.custom
ms.date	03/02/2016
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	kbMDX
helpviewer_keywords	MDX [Analysis Services], data manipulation data manipulation [MDX] Multidimensional Expressions [Analysis Services], data manipulation
ms.assetid	320fbb16-f502-4ff8-a768-20851764a66d
caps.latest.revision	29
author	Minewiskan
ms.author	owend
manager	erikre

MDX Data Manipulation Statements (MDX)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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

In This Section

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

See Also

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