Errata

Figure 1-30 (Page 29) and Figure 1-29 (Page 28) both have the same caption

The Categories table is now a column chart

Note from the Author or Editor:
The caption of Figure 1-30 at page 29 should be changed to:

FIGURE 1-30 The Office and SalesManager tables have been added to the report.

This is not an error as such but a suggestion to remove what I believe is some ambiguity in the discussion of the Earlier function at the top of P 191. The text is:

"Thus, the row context in Filter is nested inside the original row context introduced by the calculated column, which results in "it" being hidden in the innermost expression."

I believe that the authors could have written this more clearly. Again, they say that "the row context in Filter is nested inside the original row context introduced by the calculated column, which results in it being hidden in the innermost expression." When I read this I thought "the row context in Filter is nested inside, so it is in the innermost position, so the row context in Filter must be hidden. But it's actually the original row context introduced by the calculated column that is hidden. Perhaps going beyond using the word "it", and actually spelling out which context is hidden, would be more clear, or somehow avoiding the use of "inside" and "innermost".

I hope that this is clear and that I am correct about my interpretation of the meaning of this concept. I am taking the time to mention it because it is a somewhat complex topic that I struggled with for a while.

I think these authors are great.

Regards

Arthur Jenkins

Note from the Author or Editor:
Please, change the sentence in: "Thus, the row context in FILTER is nested inside the original row context introduced by the calculated column, which results in the outer filter (the calculated column one) being hidden in the innermost expression"

The book reads "In Figure 7-10 you can see the calculated column defined in DimProduct, where the table has been sorted using ListPrice ascending."

The table has actually been sorted by ListPrice descending, or ListPriceRank ascending, but not ListPrice ascending.

Thank you.

Arthur Jenkins

Note from the Author or Editor:
Correct, the phrase should end with "where the table has been sorted using ListPrice descending"

Figure 1-30 uses the same text label as Figure 1-29. It requires a text label specific to that image.

Note from the Author or Editor:
The description of Figure 1-30 should be changed to:
Office and SalesManager have been added to the report.