MDX Trek: First Contact

This presentation was first delivered at SQL Saturday #118 in Madison, WI on April 21st 2012.


Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

Click on the link below to download the slide deck, MDX script, and supporting files. I recommend extracting the contents before opening the solution.

MDX Trek First Contact Presentation Materials SQL 2008 R2

MDX Trek First Contact Presentation Materials SQL 2012



Comment from Charlie Strause
Time May 21, 2012 at 11:58 am

Thanks for making this available. I think I worked a bit with you on a project at UCare.

Comment from Mark V
Time May 22, 2012 at 8:47 am

Hi, Charlie. It’s been awhile. I’m glad it is useful for you. I hope all is well.

Pingback from Intro To MDX Decathlon–Hierarchy Navigation Basics (6/10) | Mark V SQL
Time September 4, 2012 at 1:10 pm

[…] this post, and for this section of my MDX Trek: First Contact presentation upon which this series is based, I have used an image I found on Flickr (Creative […]

Pingback from Introduction To Analysis Services Extended Events | Mark V SQL
Time February 21, 2014 at 12:00 pm

[…] Now what? Well, let’s run some queries. In my case, I just ran some of the MDX queries from my MDX Trek: First Contact presentation. The queries themselves don’t really matter. Just query a database in your SSAS […]

Pingback from Updated MDX Trek: First Contact Downloads | Mark V SQL
Time March 13, 2014 at 10:00 am

[…] After delivering my MDX Trek: First Contact presentation as part of the Pragmatic Works Free Training series on 3/11, I got some great feedback […]

Write a comment