Errata for MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance

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

“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

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]

"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.

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.

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).

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.