Building a More Complex Query

With a simple query under your belt and greater familiarity with the metadata pane, you can now assemble a slightly more complex query. In this exercise, do not be overly concerned with the query’s logic but instead focus on the use of the MDX Query Editor to assemble and execute it.

As with previous exercises, this exercise assumes you are building knowledge regarding the use of the MDX Query Editor. The level of detail provided with each step diminishes as you proceed until a level of detail consistent with exercises in the remaining chapters of this book is achieved. In future exercises, you may employ the techniques demonstrated here to assemble your queries or you may manually enter the required MDX statements. ...

Get Microsoft® SQL Server® 2008 MDX Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.