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 script
•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