There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve been part of the technical reviewers of the new book from Tomislav Piasevoli, MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, which is available on Amazon, and on the Packt website (its publisher).
The book is, as the title says, a cookbook. As any chef, you should already have a basic (or advanced) knowledge of MDX, and in this book you’ll find a lot of solutions for common problems. I was surprised to find solutions to problems I thought were impossible to solve by using MDX, for example. You will find detailed table of contents and sample chapters in the links above. I can just say that this is a must have book for any professional SSAS developer. You just cannot afford not to know the techniques described in this book – you know, you are the expert, right? Keep your skills updated!