Manipulating Data (MDX)


Applies To: SQL Server 2016

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

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.

MDX Query Fundamentals (Analysis Services)

Community Additions