| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Manipulating Data (MDX) | Microsoft Docs |
Learn how Multidimensional Expressions (MDX) can be used to manipulate the data in a variety of ways. |
05/02/2018 |
analysis-services |
mdx |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sqlas] Multidimensional Expressions (MDX) can be used to manipulate the data in a variety of ways. The following topics cover some of the more advanced concepts of data manipulation in the MDX language
| Topic | Description |
|---|---|
| Using DRILLTHROUGH to Retrieve Source Data (MDX) | Discusses the use of the MDX DRILLTHROUGH statement to retrieve the rowsets of source data applicable to a cell in a multidimensional data source |
| Working with the RollupChildren Function (MDX) | Discusses the impact of the MDX RollupChildrenfunction on the analysis of multidimensional data. |
| Understanding Pass Order and Solve Order (MDX) | Details the concepts of solve order, and how this feature affects MDX expressions, statements, and scripts. |