MDX Query Fundamentals (Analysis Services)
Multidimensional Expressions (MDX) lets you query multidimensional objects, such as cubes, and return multidimensional cellsets that contain the cube's data. This topic and its subtopics provide an overview of MDX queries.
The following topics describe MDX queries and the cellsets they produce, and provide more detailed information about basic MDX syntax.
For more information about performance issues related to MDX queries and calculations, see the section “Writing Efficient MDX” in the SQL Server 2005 Analysis Services Performance Guide.
In This Section
Provides basic syntax information for the MDX SELECT statement.
Describes what query and slicer axes are and how to specify them.
Provides a description of the purpose of the FROM clause in an MDX SELECT statement.
Describes the purpose of named sets in MDX, and the techniques needed to create and use them in MDX queries.
Provides information about calculated members in MDX, including the techniques needed to create and use them in MDX expressions.
Details the process of creating and using calculated cells.
Details the process of creating and using dimension, level, member, and cell properties.
Describes the basics behind manipulating data using drillthrough and rollup, and also describes pass order and solve order in MDX.
Describes how to use writebacks to temporarily or permanently change multidimensional data.
Describes how to use variables and parameters within MDX queries.