3 Review(s)

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