MDX Fundamentals
Pluralsight
Course Summary
This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction to MDX- 35m 7s
—Introduction 0m 41s
—Introduction to MDX 1m 6s
—Demo: Comparing MDX to SQL Part 1 6m 12s
—Demo: Comparing MDX to SQL Part 2 6m 19s
—Demo: Comparing MDX to SQL Part 3 5m 26s
—MDX Usage 4m 15s
—Multidimensional Model Terms and Concepts 3m 15s
—Tuples and Sets 6m 23s
—Summary 1m 30sBasic MDX Queries- 37m 17s
—Introduction 1m 23s
—Identifiers 4m 21s
—Tuple Request 2m 24s
—Axes 1m 22s
—Sets 1m 1s
—Demo: Axes 6m 14s
—Demo: Sets on Axes 3m 0s
—Empty Rows or Columns 0m 42s
—Demo: NON EMPTY keyword 2m 5s
—Query Resolution 2m 44s
—Cell Properties 0m 44s
—Demo: Cell Properties 4m 8s
—Dimension Properties 0m 59s
—Demo: Dimension Properties 3m 28s
—Summary 2m 42sSets- 1h 10mHierarchies in MDX- 26m 11sCalculations- 47m 43s
