THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Expert Cube Development new edition now available! #ssas #multidimensional

It is available the new edition of the advanced OLAP book, now called “Expert Cube Development with SSAS Multidimensional Models”. The previous edition was titled “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and the biggest issue of the book was… the title! In fact, there haven’t been major changes in Multidimensional since that release, despite there has been 3 new releases of SQL Server (2008 R2, 2012 and 2014). For this reason we removed the version of the product from the title. In terms of content, don’t expect any particular change. We only added a small appendix about support for DAX queries, available with Analysis Services 2012 SP1 CU4 and later versions.

I would like to highlight that, as Chris said:

  • If you already have the first edition, probably you’re not interested because you will not find new content here (just bug fixes and new screenshots)
  • The book is about SSAS Multidimensional models, if you are interested to Tabular we have another excellent book on that topic!
  • This is an advanced book, if you are a beginner with Multidimensional, wait to be more proficient before starting this book. The few negative reviews we received were from readers who tried to use this book to learn Multidimensional or as a step-by-step guide. We’d like to set the right expectations, avoiding you buy a book you don’t need.

If you want to buy it, here are a few useful links:

Have a good reading!

Published Tuesday, March 4, 2014 12:17 PM by Marco Russo (SQLBI)
Filed under: ,



Paul Hernandez said:

Hi Marco,

I recently bought the book just to help me to get back in cube development after two intensive year of only ETL development. I find it very useful and I could find a lot of best practice advices and ideas.

What I couldn't do at the moment is install the sample code. There is a view layer in top of the AdventureworksDW database. Is it possible to get the SQL scripts for these views or to find some directions about how to set the sample project?

Kind Regards,

Paul Hernandez

March 26, 2014 4:14 AM

Marco Russo (SQLBI) said:


if you download the code from the site (, you should restore the Adv_DM.bak database in SQL Server (it's in the 9908EN_Code\Solution directory of the ZIP file) - this backup contains data and views required.


March 28, 2014 6:46 PM

Massimo Morelli said:

This is indeed a fantastic book.

September 20, 2015 8:12 AM

Marco Russo (SQLBI) said:


September 20, 2015 10:23 AM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement