Great book but many of the examples doesn't run properly.

This book is the best MDX I have ever read and is deserving a 5 star rating; however, I, like many others, am unable to execute most of the samples because of the "dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified" issue.

Note that I am using SSAS 2005. I am very suprised I cannot find the answer to this seemingly easy problem anywhere on the internet including the wiley home page of this book.

Other Reviews

• MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase 2nd Edition
• Perhaps the only MDX book you'll need
• Most Definitive Guide on the Subject
• Great book but many of the examples doesn't run properly.