MDX 101

Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.

We'll start at the beginning, so you need no previous MDX experience, but it does help to understand what a cube is.

We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or (). We'll look at examples of each, and show how you can easily access the immense power of cubes with relative ease.

Presented by Alex Whittles at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 1.8 MB
    Video available MP4 Video HD 553 MB
  • SpeakerBIO
    Alex is a Data Platform MVP and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specialises in dimensional data modelling, data warehouse design, ETL systems, OLAP cubes, MDX and DAX using the SQL Server stack. Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences, and is on the SQL Bits committee. As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday, SQL Relay, PASS Summit, 24 HOP and SQL Server user groups around Europe.
  • Video