Microsoft SQL Server 2008 MDX Step by Step
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