Export (0) Print
Expand All

Advanced MDX

SQL Server 2000

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

Show:
© 2015 Microsoft