MDX Fundamentals

This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.

This course explains how to use MDX to query an Analysis Services multidimensional database. It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets. The course then focuses on how to structure queries and how to create sets to use on a query axis. The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data. Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets. This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.

• Introduction to MDX 35mins
• Basic MDX Queries 37mins
• Sets 70mins
• Hierarchies in MDX 26mins
• Calculations 47mins