Errata

There is an error in step 4 of the exercise.
Instead the Sequence Clustering algorithm, the reader should select the Clustering algorithm.

Note from the Author or Editor:
Note that in my book (first edition), the page is 404. In Exercise 3, step 4., the words

Microsoft Sequence Clustering

should be replaced with

Microsoft Clustering.

Page 108 point number 4 of Determining which configuration type to use says that (in the last sentence) Registry Entry is one of those configurations that can not have multiple properties in one configuration. This is in contrast to what is mentioned earlier on page 99 in Table 3.1 Configuration Types

Note from the Author or Editor:
this is an issue. Please change the text on pg 99, table 3-1 for Registry entry. Instead of "You can select multiple" change it to "You can only select one"

The second sentence reads (uppercasing mine):

`... It performs like a conditional if statement or CAST statement....'

I believe that should be `case', not `cast'.

Note from the Author or Editor:
confirm. Change cast to case

I don't think this is an error so much as a redundancy. In the SQL query used to get the data for the report, a couple of the join conditions are given twice:

INNER JOIN Purchasing.PurchaseOrderDetail AS pod ON p.ProductID = pod.ProductID AND p.ProductID = pod.ProductID

INNER JOIN Purchasing.PurchaseOrderHeader AS poh ON pod.PurchaseOrderID = poh.PurchaseOrderID AND pod.PurchaseOrderID = poh.PurchaseOrderID

Once for each should be enough.

Note from the Author or Editor:
The reviewer is correct, there are two redundat join conditions. Please change the part of the query at the top of the page from
I
NNER JOIN Purchasing.PurchaseOrderDetail AS pod
ON p.ProductID = pod.ProductID
AND p.ProductID = pod.ProductID
INNER JOIN Purchasing.PurchaseOrderHeader AS poh
ON pod.PurchaseOrderID = poh.PurchaseOrderID
AND pod.PurchaseOrderID = poh.PurchaseOrderID

to

INNER JOIN Purchasing.PurchaseOrderDetail AS pod
ON p.ProductID = pod.ProductID
INNER JOIN Purchasing.PurchaseOrderHeader AS poh
ON pod.PurchaseOrderID = poh.PurchaseOrderID

(just delete the second conditions in the two ON clauses).

"A KPI has four main properties: Value, Goal, Status and Target"
I believe this should read
"A KPI has four main properties: Value, Goal, Status and Trend."
This revision would be consistent with page 226 and page 227.

Note from the Author or Editor:
A KPI has four main properties: Value, Goal, Status and Trend.

?Follow these steps to set up a data source that points to the AdventureWorks2008 database?

database name is not correct. I think it should be

?Follow these steps to set up a data source that points to the AdventureWorksDW2008 database?

Note from the Author or Editor:
please correct

Step 10 ends with:

"[...] Verify in SSMS that the model appears in the Models folder"


Must be:

"[...] Verify in REPORT MANAGER HOMEPAGE that the model appears in the Models folder"

Note from the Author or Editor:
The reviewer is correct. Please change step 10 of Exercise 3 on page 525 from

Right-click the project name, and then click Deploy to deploy the report model. Verify in SSMS that the model appears in the Models folder.

to

Right-click the project name, and then click Deploy to deploy the report model. Verify in Report Manager that the model appears in the Models folder.

The explanation in the sentence before of some MDX expression refers to 2004 - "...filtered for calendar year 2004 only." Yet the MDX expression refers to 2003

Select [Measures].[Internet Sales Amount] on Columns,
[Product].[Category].Members on Rows
FROM [Adventure Works]
Where [Date].[Calendar Year].&[2003]

Note from the Author or Editor:
Select [Measures].[Internet Sales Amount] on Columns,
[Product].[Category].Members on Rows
FROM [Adventure Works]
Where [Date].[Calendar Year].&[2004]