Microsoft SQL Server 2008 Mdx Step by Step

by Smith, Bryan; Clay, C.

• ISBN13: 9780735626188
• ISBN10: 0735626189
• Edition: 1st
• Format: Paperback
• Copyright: 2009-02-25
• Publisher: Microsoft Press

Summary

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

Author Biography

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.

Table of Contents

List of Figures

List of Tables

Acknowledgements

Introduction

MDX Fundamentals

Welcome to MDX

Using the MDX Query Editor

Understanding Tuples

Working with Sets

Working with Expressions

MDX Functions

Building Complex Sets

Performing Aggregation

Navigating Hierarchies

Working with Time

MDX Applications

Enhancing the Cube

Implementing Dynamic Security

Building Reports

Appendix : Appendix

Table of Contents provided by Publisher. All Rights Reserved.