Intro To MDX Decathlon-The Basic MDX Query

In the previous post in this series, Intro to MDX Decathlon - Cube Space: The Final Frontier (1/10), we learned the terminology we use when talking about cubes and cube space. We also gave a little primer on a helpful way to imagine the cube space while working with MDX.

In this post, we will start looking at the basic structure and syntax of MDX queries. But first, let's set the stage by showing how to get to the MDX Query Designer in SQL Server Management Studio (SSMS).