Microsoft SQL Server 2008 Mdx Step by Step  (English, Paperback, Smith Nanny)

This book does not come with a CD

With this practical, learn-by-doing tutorial, 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

Table of Contents

Part 1: MDX Fundamentals
1. Welcome to MDX
2. Using the MDX Query Editor
3. Understanding Tuples
4. Working with Sets
5. Working with Expressions
Part 2: MDX Funtions
6. Building Complex Sets
7. Performing Aggregation
8. Navigating Hierarchies
9. Working with Time
Part 3: MDX Applications
10: Enhancing the Cube
11. Implementing Dynamic Security
12. Building Reports