Microsoft® SQL Server® 2008 MDX Step by Step Brian J Smith PDF

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