Book 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
Table of contents
-
Microsoft® SQL Server® 2008 MDX Step by Step
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- A Note Regarding Supplemental Files
- List of Figures
- List of Tables
- Acknowledgements
- Introduction
- I. MDX Fundamentals
- II. MDX Functions
- III. MDX Applications
- Appendix
- Index
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Microsoft® SQL Server® 2008 MDX Step by Step
- Author(s):
- Release date: February 2009
- Publisher(s): Microsoft Press
- ISBN: 9780735626188