MDX Data Manipulation - Manipulating Data
Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium
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
In This Section
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. |