Udostępnij za pośrednictwem


Manipulating Data (MDX)

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

Other Resources

MDX Query Fundamentals (MDX)

Help and Information

Getting SQL Server 2005 Assistance