This book's samplese does not match with AdventureWorksDW2012 sample file provided
I have the same problem but noticed it right from the beginning. The authors used a newer version than what is provided on this Wrox website. I sent an email to support and they said they can't help with coding issues - of course it wasn't a coding issue - it’s a mismatch of the book purchased to the provided samples.
Run a select in the data warehouse and you will find something like this -
11.00.20120216.00 2012-02-16 00:00:00.000
I have actually spent hours looking for the most recent version and found many different versions out there so good luck in the hunt. The authors/Wrox and Wiley all remove themselves of any responsibility for the code and I understand that but if you are a first time developer trying desperately to utilize this book, you will get lost fast. I am looking at purchasing another source for information. Poor job in implementing to some of us less knowledgeable is the root cause, if you are already well versed in Cube creation and especially mdx statements this book works just fine I would suppose.
If anyone has a clue where the latest Data warehouse is located – please inform Wrox support so they have a clue.