About The Book

Your hands-on, step-by-step guide to the data-access query language for SQL Server Analysis Services.



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 scr ipt

Implement dynamic security to control data access

Develop MDX-driven reports in SQL Server Reporting Services CD features:

Practice exercises

Database and code samples

Fully searchable eBook