Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions.

Discover how to:

* Construct and execute MDX queries
* Work with tuples, sets, and expressions
* Build complex sets to retrieve the exact data users need
* Perform aggregation functions and navigate data hierarchies
* Assemble time-based business metrics
* Customize an Analysis Services cube through the MDX script
* Implement dynamic security to control data access
* Develop MDX-driven reports in SQL Server Reporting Services