Events
Become a Certified Fabric Data Engineer
Jan 14, 11 PM - Mar 31, 11 PM
Check your eligibility for an exam discount offer and register for free live sessions to prepare for Exam DP-700.
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
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.
Topic | Description |
---|---|
The Basic MDX Query (MDX) | Provides basic syntax information for the MDX SELECT statement. |
Restricting the Query with Query and Slicer Axis (MDX) | Describes what query and slicer axes are and how to specify them. |
Establishing Cube Context in a Query (MDX) | Provides a description of the purpose of the FROM clause in an MDX SELECT statement. |
Building Named Sets in MDX (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 (MDX) | Provides information about calculated members in MDX, including the techniques needed to create and use them in MDX expressions. |
Building Cell Calculations in MDX (MDX) | Details the process of creating and using calculated cells. |
Creating and Using Property Values (MDX) | Details the process of creating and using dimension, level, member, and cell properties. |
Manipulating Data (MDX) | Describes the basics behind manipulating data using drillthrough and rollup, and also describes pass order and solve order in MDX. |
Modifying Data (MDX) | Describes how to use writebacks to temporarily or permanently change multidimensional data. |
Using Variables and Parameters (MDX) | Describes how to use variables and parameters within MDX queries. |
Events
Become a Certified Fabric Data Engineer
Jan 14, 11 PM - Mar 31, 11 PM
Check your eligibility for an exam discount offer and register for free live sessions to prepare for Exam DP-700.
Learn moreTraining
Module
Transform data by implementing pivot, unpivot, rollup, and cube - Training
This content is a part of Transform data by implementing pivot, unpivot, rollup, and cube.
Certification
Microsoft Certified: Azure Data Fundamentals - Certifications
Demonstrate foundational knowledge of core data concepts related to Microsoft Azure data services.