Microsoft SQL Server 2008 MDX Step by Step,

Description

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

CONTENTS:

List of FiguresList of TablesAcknowledgementsIntroductionPart I: MDX Fundamentals
* Chapter 1: Welcome to MDX
* Chapter 2: Using the MDX Query Editor
* Chapter 3: Understanding Tuples
* Chapter 4: Working with Sets
* Chapter 5: Working with ExpressionsPart II: MDX Functions
* Chapter 6: Building Complex Sets
* Chapter 7: Performing Aggregation
* Chapter 8: Navigating Hierarchies
* Chapter 9: Working with TimePart III: MDX Applications
* Chapter 10: Enhancing the Cube
* Chapter 11: Implementing Dynamic Security
* Chapter 12: Building ReportsAppendix : Appendix