Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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

Subscriber Reviews

Average Rating: 3.4285714285714284 out of 5 rating Based on 7 Ratings

"Microsoft® SQL Server® 2008 MDX Step by Step" - by Anonymous on 23-JUN-2014
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
First Chapter
Report as Inappropriate

"Logically Progresses" - by Mr Zu on 02-JUL-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Bryan Smith is an excellent guide to the intricacies of MDX.

The exercises are designed to walk you logically through the central concepts of OLAP cubes and the MDX query language, beginning with tuples, sets and expressions and then building more the complex queries required by most applications.

Report as Inappropriate

"Perfect !" - by Lidong on 17-JUN-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
it's really perfect book introducing MDX, I learned a lot from it. Thakns the author.
Report as Inappropriate

"best into to MDX ever" - by Karol K on 17-MAR-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I love this book, awesome job Bryan and Ryan
Report as Inappropriate