Microsoft SQL Server 2008 MDX Step by Step and over 2 million other books are available for Amazon Kindle . Learn more

Trade in Yours
For a £10.84 Gift Card
Trade in
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Microsoft SQL Server 2008 MDX Step by Step on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft® SQL Server® 2008 MDX Step by Step [Paperback]

Bryan C Smith , C Ryan Clay , Hitachi Consulting
3.0 out of 5 stars  See all reviews (2 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Kindle Edition £19.59  
Paperback --  
Trade In this Item for up to £10.84
Trade in Microsoft® SQL Server® 2008 MDX Step by Step for an Amazon Gift Card of up to £10.84, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

7 Mar 2009 0735626189 978-0735626188 1

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

Product details

  • Paperback: 392 pages
  • Publisher: Microsoft Press; 1 edition (7 Mar 2009)
  • Language: English
  • ISBN-10: 0735626189
  • ISBN-13: 978-0735626188
  • Product Dimensions: 18.9 x 2.3 x 23.7 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 462,014 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

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

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4 star
3 star
2 star
3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
This book is an excellent learning material to learn the MDX language. It takes you from the elementary to intermediate/advanced level.

You might have challenges installing the sample database as is common with installing some databases included in study materials.

Please follow the instructions as stated in the book BUT DELETE THE .LDF FILE FROM THE LOCATION YOU ARE ATTACHING THE DATABASE FROM. The installation process will create a new .LDF file and you should be fine from then on.

Excellent book, excellent job, highly recommend.
Comment | 
Was this review helpful to you?
2 of 7 people found the following review helpful
1.0 out of 5 stars Awful 23 April 2012
Format:Paperback|Verified Purchase
Lazy, incompetent and stupid would be the best way to describe this book. The authors/publishers are too lazy, stupid, sleazy and incompetent to even bother providing the sample databases etc. in a workable state. I have spent an entire frustrating day trying to get what these sleazy incompetents put in the book to work to even bother going any further.
Don't waste your money buying this book - the online solutions do not work and they do not give a monkeys that you have spent £25 on their pathetic rubbish.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.7 out of 5 stars  11 reviews
16 of 16 people found the following review helpful
5.0 out of 5 stars Best book on mdx in market 16 Mar 2009
By kamran arab - Published on
Format:Paperback|Verified Purchase
I have read several other texts and I can say that none of them were complete. Some texts had good theory but lacked database sample where you could run the exact same queries, verify results and tinker a little to gain understanding. This book not only comes with a sample database (relational and dimensional), the queries and the databases actually match 100%. Learning Sql or MDX is like learning mathematics - you can't learn it just by reading, exercising the skills is essential.

Step-by-step is very effective approach for new comers so basically this book is ideal for beginners. At the same time it gives you enough details to be an advance user. This book is not for people with MDX skills already under their belt and looking for a reference book. They will be bored with simplistic approach used for beginners. I have been waiting for this book for months and I am not disappointed.
6 of 6 people found the following review helpful
4.0 out of 5 stars A good foundation 17 Mar 2009
By Eldred Rivera - Published on
Brian and Ryan presented a very simple and literally step by step way to understand the fundamental syntax of MDX. In addition, the examples are good starting points to be adventurous and to try other stuff. The chapters are arranged in a very logical manner. Each chapter builds upon the knowledge picked-up from the previous one.
However, do not let Chapter 1 discourage you from continuing to explore the rest of the book. The attempt to present the wealth of business intelligence, dimensional model and data warehouse terms and structure may get to be confusing. I agree with them when they wrote that a familiarity of the concept of data warehousing is recommended. To better appreciate the whole exercise of learning MDX, a basic knowledge of Analysis Services will go a long way.

Lastly, finishing the book with a chapter on using MDX with reporting services shows the main purpose of learning MDX in the first place, provide meaningful information to the end users in a format they will appreciate.

Eldred Rivera, MCT
4 of 4 people found the following review helpful
5.0 out of 5 stars Hard to beat 16 April 2010
By Jaewoo Kim - Published on
Format:Paperback|Verified Purchase
If you are a beginner to intermediate MDX person, then I can't think of any better book on the subject. Don't let the "step-by-step" label misguide you into believing this book is only for the beginners. This book covers from the simple to the complex MDX queries.

The book deals from the very basic "Select { } on columns, { } on rows from [Cube]" to using Expressions, Aggregation, and navigating the hierarchies. You will learn to use all MDX keywords, functions, and syntax structures.

I would not recommend this book as a first book on SQL BI (I like Brian Larson's "Delivering Business Intelligence"). Rather, this book should be an important supplement to anyone's SQL BI knowledge. Although SQL 2008 provides a handy GUI to build a MDX queries on an existing cube, it is not a good substitute for complex MDX queries. Trust me, when the pressure is on, and the senior management wants to get key information in a hurry, understanding MDX well can save you a lot of stress and reduce the blame game so prevalent in IT.

If you are never going to use MDX, I would question the need to build and process Cubes (also called Data Mart) all together. If you have a solidly designed Data Warehouse and a well functioning ETL process, you can just query the DW using SQL for most of the information you would need. But MDX releases the potential of the Cube and makes the entire SQL BI, and the Cube in particular, far more valuable and usable.

MDX is used across multiple Business Intelligence platforms. Even if you do not plan to exclusively use SQL BI, this book will help you to understand MDX that you can apply to, let's say, Microstrategy and SAS.

This book also comes with a CD that provides sample SQL BI Development Project and a corresponding Data Warehouse database.

If you want a well written, highly structured, and clear explanations of MDX from simple to complex, then this book is the right book for you.
2 of 2 people found the following review helpful
5.0 out of 5 stars Very good if you want to learn MDX 30 July 2010
By Programmer - Published on
Format:Paperback|Verified Purchase
I tried several other books on MDX, and for beginner, this is head and shoulders above the rest. There are some issues with installing samples from CD, but once you past that, it's a smooth sailing. I went through the book literally step by step, and it worked well for me.
4 of 5 people found the following review helpful
4.0 out of 5 stars It's good to see a book on MDX from MS Press 6 Aug 2009
By N. Erickson - Published on
It's SQL Server 2008 MDX Step by Step and it delivers what you need to get your teeth into MDX. In the way most Step by Step books from Microsoft Press do, but I probably wouldn't recommend the book to people already fluent with MDX.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category