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
Sprache
Verlagsort
Zielgruppe
Maße
Höhe: 229 mm
Breite: 187 mm
ISBN-13
978-0-7356-2618-8 (9780735626188)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Bryan C. Smith is an architect with Hitachi Consulting, where he implements data warehouse solutions with SQL Server. He also leads Analysis Services and MDX training courses, participates in the Analysis Services forums on MSDN, and is coauthor of Professional SQL Server 2008 Reporting Services.
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
