---
title: "Manipulating Data (MDX) | Microsoft Docs"
ms.custom: ""
ms.date: 01/19/2019
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "analysis-services"
ms.topic: conceptual
helpviewer_keywords: 
  - "MDX [Analysis Services], data manipulation"
  - "data manipulation [MDX]"
  - "Multidimensional Expressions [Analysis Services], data manipulation"
ms.assetid: 4865192e-f46b-4ce5-b51c-9e08dbad5b85
author: minewiskan
ms.author: owend
manager: craigg
---
# Manipulating Data (MDX)

Multidimensional Expressions (MDX) can be used to manipulate the data in a variety of ways. The article listed in this article cover some of the more advanced concepts of data manipulation in the MDX language.

## In This Section

|Topic|Description|  
|-----------|-----------------|  
|[Using DRILLTHROUGH to Retrieve Source Data (MDX)](mdx-data-manipulation-retrieve-source-data-using-drillthrough.md)|Discusses the use of the MDX [DRILLTHROUGH](/sql/mdx/mdx-data-manipulation-drillthrough) statement to retrieve the rowsets of source data applicable to a cell in a multidimensional data source|  
|[Working with the RollupChildren Function (MDX)](mdx-data-manipulation-rollupchildren-function.md)|Discusses the impact of the MDX [RollupChildren](/sql/mdx/rollupchildren-mdx)
|[Understanding Pass Order and Solve Order (MDX)](mdx-data-manipulation-understanding-pass-order-and-solve-order.md)|Details the concepts of solve order, and how this feature affects MDX expressions, statements, and scripts.|  

<!-- ??

|[Script for Search and Replace] function on the analysis of multidimensional data.|

GeneMi is removing this commented row because it is unclear what article its link meant to link to.
Also, I had to add its leading '|' character, for consistency to aid bulk automated updated to our markdown source code.

GeneMi , 2019/01/19
-->

## See Also

[MDX Query Fundamentals (Analysis Services)](mdx-query-fundamentals-analysis-services.md)