Analysis Services
Advanced MDX
The Multidimensional Expressions (MDX) syntax is designed not only to extract simple data from multidimensional data sources, but also to provide additional functionality to create named sets, calculated members, and write information back to dimensions and cells.
The following topics cover the more advanced aspects of MDX syntax.
| Topic | Description |
|---|---|
| Creating and Using Property Values | Details the process of creating and using dimension, level, member, and cell properties |
| Building Named Sets in MDX | Describes the purpose of named sets in MDX and the techniques needed to create and use them in MDX queries |
| Building Calculated Members in MDX | Provides information about calculated members in MDX, including the techniques needed to create and use them in MDX expressions |
| Building Caches in MDX | Gives information about caches in MDX, including the techniques needed to create and use them in MDX queries |
| Building Calculated Cells in MDX | Details the process of creating and using calculated cells |
| Creating and Using User-Defined Functions in MDX | Details the creation and use of external function libraries and user-defined functions in MDX |
| Using Writebacks | Describes the technique of writing information back into the dimensions and cells of multidimensional data sources using MDX |
| Using DRILLTHROUGH to Retrieve Source Data | Discusses the use of the MDX DRILLTHROUGH statement to retrieve the rowsets of source data applicable to a cell in a multidimensional data source |
| Understanding Pass Order and Solve Order | Details the concepts of pass order and solve order, and how these features affect MDX queries and expressions |