Errata
Chapter 2, page 28
Instead of: Web customers purchase AWC products online through the AWC Intranet website.”
Should be:
Web customers purchase AWC products online through the AWC Internet website.”
Chapter 2, page 63, step 4 (corrected in third print)
Instead of: From the SalesOrderDetail table check the SalesOrderNumber, OrderDate, TerritoryID, Status columns. From the SalesOrderHeader table select the SalesOrderDetailID, ProductID, OrderQty, UnitPrice and UnitPriceDiscount columns.
Should be:
From the SalesOrderHeader table check the SalesOrderNumber, OrderDate, TerritoryID, Status columns. From the SalesOrderDetail table select the SalesOrderDetailID, ProductID, OrderQty, UnitPrice and UnitPriceDiscount columns.
Chapter 3, section 3.1.3 (corrected in second print)
Optionality is no longer an attribute relationship property. It was dropped in the final release of SSAS.
Chapter 4
The footer text is wrong. Should be Working with Dimensions and Measures.
Chapter 6, page 200, item 6
Instead of: In the Completing the Wizard step, don’t check, name the dimension Product.
Should be:
In the Completing the Wizard step, name the dimension Product.
Chapter 7, section 7.3.6, pages 252-253
The Random Guess line in the Lift Chart appears only if a state of the predicted column is selected. This line was removed in the release version because it was not a correct representation of a random guess with a multi-state predicted column.
Chapter 9, section 9.1.3, pages 293
Instead of: For example, the shaded cell in Figure 9.3 is located at coordinates Product -> Product -> Mountain-100, Date -> Year -> 2004, Sales Territory -> Country -> All Countries.
Should be:
For example, the shaded cell in Figure 9.3 is located at coordinates Product -> Product -> Road-200, Date -> Year -> 2003, Sales Territory -> Country -> Canada.
Chapter 10, page 200 bottom
Follow similar steps to create the Location dimension.
The Location Template is not included in the release build of Analysis Services. Use the Location dimension from the Code\Ch06\Adventure Works Inventory Template folder or copy it to C:\Program Files\Microsoft SQL Server\90\Tools\Templates\olap\1033\Dimension Templates.
Chapter 16, Listing 16.1 (corrected in third print)
Instead of: Dim member As Member = expr.Calculate(Nothing).ToMember()
Should be: Dim member As Member = expr.CalculateMdxObject(Nothing).ToMember()
page 523 (top): Instead of “If the role denies explicitly a given right, than the role members will be denied that right regardless of the fact that another role they are members of may grant them the same right.”
Should be: SSAS doesn’t support a strong deny. Implicit or explicit allowed sets take precedence over explicitly denied sets with additive roles.
Chapter 18, Page 627 top
Instead of: Notice that once an entity attribute is added to the report, the Explorer pane changes to a tree that lists only the dimensions and measure groups that are referenced by the dimensions containing the attribute.
Should be: Notice that once an entity attribute is added to the report, the Explorer pane changes to a tree that lists only the dimension attributes and the measure groups that are referenced by the dimensions containing the attribute.
Chapter 19, Page 655, 4th line
Instead of: We have to options to evaluate the KPI.
Should be: We have two options to evaluate the KPI.
