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.

See Also

MDX Query Fundamentals (Analysis Services)