Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |