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
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.
C. Ryan Clay is a solution architect for Hitachi Consulting, where he develops business solutions based on Microsoft technologies, including OLAP and MDX-based applications. Active in supporting the Microsoft business intelligence community, he’s presented at Microsoft Tech*Ed, SQL PASS, and MSDN events.
Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services
Comments about Microsoft Press Microsoft® SQL Server® 2008 MDX Step by Step:
I recently bought this book to help with my work in querying cubes from Excel.Aside from a few quibbles, I like the book, and found it helped in my objective.The 3 part format of the book was good, Part 1 covered my immediate objective, but parts 2 and 3 made interesting reading, and has helped my gain a better understanding.A fuller review can be read at [@]
Bottom Line Yes, I would recommend this to a friend