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

Downloads

Downloads

Follow the instructions to download this book's companion files or practice files.

1. Click the Download button below to start the download.
2. If prompted, click Save.
3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

Sample Content

Sample Pages

Download the sample content

Table of Contents

• List of Figures
• List of Tables
• Acknowledgements
• Introduction
• Part 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 Expressions
• Part II: MDX Functions
  • Chapter 6: Building Complex Sets
  • Chapter 7: Performing Aggregation
  • Chapter 8: Navigating Hierarchies
  • Chapter 9: Working with Time
• Part III: MDX Applications
  • Chapter 10: Enhancing the Cube
  • Chapter 11: Implementing Dynamic Security
  • Chapter 12: Building Reports
• Appendix : Appendix

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Submit Errata