Errata

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

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

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 182
Step 5 of Exercise 1

Text reads "On the Select New Dimensions page, clear the Dim Product check box ....". I think it should read "On the Select Existing Dimensions page, clear the Dim Product check box ...".

 Esteban Aramayo  Jan 10, 2013 
Printed, PDF Page 205
Step 6

This step provides instructions on how to enter a measure expression to convert sales measures to USD. The example shows an expression for converting the Reseller Sales Amount measure. If I browse the cube and drop Reseller Sales Amount in the "Drop Totals or Detail Fields" area it shows $76,150.13. If I execute the following SQL directly against the database it produces 88,458,802.300588.

SELECT
SUM (rs.SalesAmount / cr.AverageRate)
FROM dbo.FactResellerSales rs INNER JOIN dbo.FactCurrencyRate cr
ON rs.OrderDateKey = cr.DateKey and
rs.CurrencyKey = cr.CurrencyKey

Note from the Author or Editor:
version issue

 Howard Jones  Jan 16, 2012 
PDF Page 213
1st paragraph

After the text: "In the Attributes pane, right-click the source attribute that is on the ?one? side of the relationship, and then select New Attribute Relationship",
and after the figure 6-2,

appears the text: "Make sure that the Name drop-down list below Source Attribute shows the attribute that is on the ?many? side of the relationship and that the Name drop-down list below Related Attribute shows the attribute on the ?one? side of the relationship."

There is a contradiction between the 2 texts, because the Source Attribute is the one being right-clicked. So it can't be on the "one" side and on the "many" side at the same time. I think the first text is wrong.

 IRIMIA BOGDAN  Feb 01, 2014