Errata for Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model

First paragraph says: "...and drag the EnglishDescription column down to below the new Color level to create the bottom level, as shown in Figure 2-32." But, in Figure 2-32, the screenshot shows EnglishProductName as the bottom level of the hierarchy.

Note from the Author or Editor:
Correct - the text should be EnglishProductName instead of EnglishDescription, like you can see in the Figure 2-32.

Pg132 / Table 4-2 Result for "0 / 0" has been mentioned as Infinity however when I am trying the same in local installation of SSAS Tabular, I am getting "NaN" as result Pg133 / Examples for Blank() - after paragraph 6 Result for "Blank() || Blank()" has been mentioned as Blank() however when I am trying the same in local installation of SSAS Tabular, I am getting "False" as result Result for "Blank() && Blank()" has been mentioned as Blank() however when I am trying the same in local installation of SSAS Tabular, I am getting "False" as result -------------------------------------------------------- Tabular Instance Version - Microsoft Analysis Server 11.0.2100.60

Note from the Author or Editor:
You are correct for both pages. Page 132 / Table 4-2 The third row has "0 / 0" in Expression column must have "NaN" value in Result column (instead of current "Infinity") Page 133 The last two examples at the bottom of the page have to be replaced with the following: BLANK() || BLANK() = FALSE BLANK() && BLANK() = FALSE

The expression listed in the text: "CalcAmountB := SUMX( FILTER( Orders, Orders[Quantity] > 1 ), Orders[Amount] )" Doesn't match with the descirption a few paragraphs later which says "the Filter function skips just the <Internet, Green, Small> row from the table you saw in Figure 5-12 (which has a price of 1 and is excluded by the filter condition)." I believe the second argument to the Filter function in the formula should be "Orders[Price] > 1" rather than "Orders[Quantity] > 1"

Note from the Author or Editor:
You are right, the condition of FILTER should be Orders[Price] > 1 instaed of Orders[Quantity]. Thanks for reportin this.

The text reads: "Note: The Process Recalc operation that is performed within Process Full of a table automatically refreshes all calculated columns in other tables that depend on the table that has been processed. For this reason, Process Full over tables does not depend on the order in which it is executed in different transactions, distinguishing it from the Process Defrag operation." I was wondering whether instead of refering to 'Process Defrag', the intention was actually to refer to Process Default', as this would make more sense base on the explanation of 'Process Default' earlier on in the section.

Note from the Author or Editor:
In the note box the term "Process Defrag" has to be changed to "Process Default" - the correct complete box becomes: Note The Process Recalc operation that is performed within Process Full of a table automatically refreshes all calculated columns in other tables that depend on the table that has been processed. For this reason, Process Full over tables does not depend on the order in which it is executed in different transactions, distinguishing it from the Process Default operation.

I only have the "Kindle" version of the book, so the page number provided is the "location". There is a problem with the large DAX query listed after this sentence: "Instead you must use a special DAX function called ALLSELECTED". When ran the query against AdventureWorksDW it produces the following error: Query (21, 9) The value for column 'Product Category Name' in table 'Product Category' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. Based on my understanding, the problem is caused by this FILTER condition: FILTER( 'Product Category'[Product Category Name], 'Product Category'[Product Category Name] = "Accessories" || 'Product Category'[Product Category Name] = "Clothing" ) changing it to: ('Product Category'[Product Category Name] = "Accessories" || 'Product Category'[Product Category Name] = "Clothing" ) fixes the issue and the query returns correct results.

Note from the Author or Editor:
You're right. This is at page 255 in the printed book. This part of the query at page 255: FILTER( 'Product Category'[Product Category Name], 'Product Category'[Product Category Name] = "Accessories" || 'Product Category'[Product Category Name] = "Clothing" ) must be replaced by: ('Product Category'[Product Category Name] = "Accessories" || 'Product Category'[Product Category Name] = "Clothing" )