Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2012 > Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 17th, 2013, 12:53 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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?
Reply With Quote
  #2 (permalink)  
Old March 5th, 2013, 02:32 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.

Regards,
Reply With Quote
  #3 (permalink)  
Old March 5th, 2013, 02:37 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04: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



All times are GMT -4. The time now is 01:58 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.