Wrox Programmer Forums
Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX by Sivakumar Harinath, Ronald Pihlgren, Denny Guang-Yeu, Lee; ISBN: 978-1-118-10110-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 17th, 2013, 01:53 PM
Registered User
Join Date: Feb 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't replicate "Time Intelligence" example (Chapter 8, p. 301-305)

I'm new to BI and bought this book to learn SSAS, so I'm very dependent on the step-by-step guides as I have little practical experience.
I follow the guide and encounter 2 problems.

Figure 8-36 shows Sales Amount from 2001-2005. I have no sales on those periods in the sample data? I find date for the period 2005-2010. So I guess the author might have used an older version of Adventure Works DW?

Then when I export to Excel, I only get sales from 2005! I'm guessing this is a default member member problem or something. I just have no idea how to fix it to show for more than one year. I haven't skipped any chapters and am therefore very confused with this sudden disconnect.

Please help?
Old March 5th, 2013, 03:32 PM
Registered User
Join Date: Mar 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 -
DBVersion VersionDate
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.

Old March 5th, 2013, 03:37 PM
Registered User
Join Date: Feb 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Copy paste from 2008 book

I found out that he main reasons of many of the mismatches is due to the fact that it is literally copy-pasted from the 2008. Whole pages are completely identical with only the screenshots that is different. So I guess they just haven't been prudent enough in updating the information.
I really like the book, but it is just difficult to manage whether it is my incompetence or theirs that make it fail.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Time Error 2683 "There is no Object in this Control" SunnySide Access 0 October 2nd, 2012 09:51 AM
MSXSL gives error message for "for" inside "select" ilyaz XSLT 1 December 9th, 2010 05:02 PM
How to theme the "Browse" button of "FileUpload" control? varunbwj BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 2 October 14th, 2009 01:22 AM
Add a CheckBox DataColumn to my DataGridView, Null format: "" or "True" but Error: F ismailc C# 2005 0 September 25th, 2009 04:56 AM
Code not going as planned: "icicle" vs "savedinstancestate" joopthecat BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 3 May 3rd, 2009 03:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.