View Single Post
  #1 (permalink)  
Old February 17th, 2013, 01:53 PM
jross jross is offline
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