and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading MDX with Microsoft SQL Server 2008 R2 Analysis Services C... on your Kindle in under a minute.

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

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook [Paperback]

Tomislav Piasevoli
5.0 out of 5 stars  See all reviews (6 customer reviews)
Price: CDN$ 54.05 & FREE Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Tuesday, September 23? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $16.49  
Paperback CDN $54.05  
Save Up to 90% on Textbooks
Hit the books in's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
Join Amazon Student in Canada

Book Description

July 1 2011 1849681309 978-1849681308

80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries

  • Enrich your BI solutions by implementing best practice MDX calculations
  • Master a wide range of time-related, context-aware, and business-related calculations
  • Enhance your solutions by combining MDX with utility dimensions
  • Become skilled in making reports concise
  • Learn how to optimize, dissect, and debug your MDX calculations
  • Maximize your learning with detailed explanations following each solution
  • Packed with practical, hands-on cookbook recipes, illustrating the techniques to enrich your Business Intelligence solutions

In Detail

Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language.

This cookbook contains over 80 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries.

Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations.

In the first half of the book you will learn how to efficiently work with time, strings, metadata, calculated members and sets in general, and how to implement MDX solutions that are appropriate in a particular context: a time-aware calculation, a concise report, a calculation relative to another. You will also learn how to implement various types of conditional formatting, how to perform typical MDX calculations like ranks, percentages and averages, and year-to-date calculations.

The book then deep dives into topics such as enhancing cube design with utility dimensions, context-aware calculations, and other advanced topics. In this part you will learn how a utility dimension can be of great help, for example when you want to calculate histograms or implement time-based calculations. The advanced topics also cover parent-child hierchies, recursion, random values, and complex sorts.

Enrich your Business Intelligence solutions with over 70 recipes for high-performance MDX calculations and flexible MDX queries

What you will learn from this book

  • Create time-aware calculations (relative to the current date))
  • Create context-aware calculations (relative to members on axes)
  • Implement business-related calculations like forecasting, allocation of values and ABC analysis
  • Calculate various percentages, averages, and ranks
  • Work with related members (on the same and other dimensions)
  • Combine MDX with utility dimensions
  • Implement error handling
  • Implement AND, OR, NOT logic
  • Conditionally format your MDX calculations
  • Optimize, dissect, and debug MDX calculations and queries
  • Capture MDX generated by SSAS front-ends
  • Register SSAS-related assemblies and use stored procedures in them


This book offers practical, task-based, and immediately usable recipes covering a wide range of MDX calculations and queries. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, the explanations are done in great detail, which makes it good learning material for everyone who has experience in MDX and wants to improve.

The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. However, some of the recipes depend on each another. When this is the case, you will be notified.

The book is focused on Microsoft SQL Server 2008 R2 Analysis Services, but most of the concepts and explanation are also applicable to previous versions of Microsoft SQL Server Analysis Services.

Who this book is written for

If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you.

The book assumes you have a working knowledge of MDX and a basic understanding of dimensional modeling and cube design.

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Frequently Bought Together

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook + Expert Cube Development with Microsoft SQL Server 2008 Analysis Services + Star Schema The Complete Reference
Price For All Three: CDN$ 152.34

Customers Who Bought This Item Also Bought

Product Details

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

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars Must have for all MDX developers Nov. 15 2011
I am always trying to keep my MDX and Analysis Services skills up-to-date and so I am always looking for new books that cover those topics. Recently I came across Tomislav Piasevoli's new "MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook". When I read the first chapters I realized very fast, that book has great potential for all kinds SSAS/MDX developer. For beginners the examples provided are easy to follow and very well described and the fact that he focused on real world scenarios makes the entry into the multidimensional world very intuitive. Beginners will have many quick wins as they can simply copy the examples and adopt them to their cube which I think is the best way to start with MDX. Advanced developers will like the additional information he provides for all examples. He describes pros and cons of several implementations and used techniques especially in terms of performance and usability. The best practices he provides thereby are also good guidelines for beginners and will prevent them from making very common mistakes every developer had to struggle with in the beginning. Even experts that have been working with MDX and Analysis for several years now and consider themselves to have very good skills in both domains, I think will still benefit from reading this book. It is always interesting to see, how other people solve common business requirements to broaden one's mind. If you are developing BI solutions every day it is very likely that you stop thinking about your own solution in detail very fast and will be implementing the same solution over and over again even though there may be better solutions out there. Tomislav highlights many of those solutions and shares them with this book.

In general the book is very well structured.
Read more ›
Was this review helpful to you?
5.0 out of 5 stars Practical and Concise Oct. 28 2011
By tlachev
MDX is the query language for multidimensional cubes. Many BI practitioners perceive MDX to have a high learning curve probably not that much for the language itself but for the multidimensional concepts you need to master before you can get something out of it. When interacting with the community, I am frequently asked to recommend a MDX book. So far, my recommendations have been Microsoft SQL Server 2008 MDX Step by Step by Brian Smith at el for beginners and MDX Solutions by George Spofford at el for more advanced users.

I will add MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli (MVP - SQL Server) to my recommendation list. This book takes an interesting approach that will be particularly appealing to readers who have already mastered the basics. As its name suggests, the book is a collection of recipes that you can quickly refer to when you tackle a specific MDX requirement. For example, suppose you need to obtain the last date with data in the cube. You flip to Chapter 2: Working with Time and you find a section Getting Values on The Last Date With Data. In it, the author provides the necessary background to explain the concept and provides a 9-step recipe for implementing it. Besides its practical and concise style, another thing that I liked about this book is that it targets the Adventure Works cube so you don't have to spend time installing and learning other databases. You can hit the ground running by just copying and executing the query.

All in all, this is great book to add to your repertoire of Analysis Services books. The author is an industry-recognized expert who has many years of experience in developing BI solutions with Analysis Services and this becomes evident quickly. Get the recipes!
Was this review helpful to you?
5.0 out of 5 stars Take your MDX skills to the next level Oct. 25 2011
There are not many MDX books available, so when a new one arrives on the market, I definitely want to take a look. Now I have taught MDX classes for many years, and I think perhaps my first class was in 2002. However, it's been so long now, I don't recall exactly when that first class was. What I do know is that my understanding of MDX and my fluency with the language has grown by leaps and bounds since then through experience with all kinds of bleeding edge MDX, and I have tried to communicate some of my insights developed along the way to students in my classroom. MDX concepts can stretch your thinking (to put it mildly), and more so if you have to unlearn SQL concepts as well, which is true of the majority of my students. As a native English speaker, I can find it challenging at times to explain certain aspects of MDX. For all these reasons, I can fully appreciate Tomislav's efforts to create this book and commend him for his excellent examples and explanations using a language that is not his mother tongue.

Tomislav's book is definitely not for beginners. There is an underlying assumption that you already have some familiarity with the basics of MDX. The purpose of this book is to provide you with the tools necessary to continue building your skills. The chapters group together a series of related concepts, called recipes. You don't need to read the book sequentially from cover to cover. Instead, you search for the desired outcome, such as handling division by zero errors (described in Chapter 1) or calculating row numbers (found in Chapter 7). Ideally, you don't just read the recipe, but actually try out the steps yourself. I did some of my reading of this book when I was away from my laptop, and frequently found that I wanted to try out something that Tomislav mentioned.
Read more ›
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category