Errata for MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Other Digital Version |
CD-ROM
|
Readiness Review answer incorrect
In the Readiness Review assessment, one of the questions reads:
"Can a local administrator be denied "data access" to a SQL Server Analysis Services (SSAS) cube on the same server?"
The correct answer should be:
"Yes, local windows administrators can be denied access to an SSAS cube, but the only way to accomplish this is to exclude the administrator group from the server administrator role."
|
Microsoft Press |
May 06, 2010 |
|
| Printed |
Page 81
|
Additional information is needed in Step 3
On page 81, Step 3 is missing instructions to click "New" after selecting the "Create A Data Source Based On A New Or Existing Connection" radio button.
Change:
"3. In the Data Source Wizard, select the Create A Data Source Based On A New Or Existing Connection radio button in the Select How To Define The Connection page."
To:
"3. In the Data Source Wizard, on the Select How To Define The Connection page, verify that Create A Data Source Based On A New Or Existing Connection is selected and then click New."
|
Microsoft Press |
Jul 13, 2010 |
|
| Printed |
Page 97
|
"Lookup" should be "Aggregate"
On page 97, Step 2 contains an incorrect transformation.
Change:
"2. Connect the output of the Lookup to the new OLE DB Destination by dragging the green path arrow from the Lookup transformation onto the OLE DB Destination
adapter."
To:
"2. Connect the output of the Aggregate to the new OLE DB Destination by dragging the green path arrow from the Aggregate transformation onto the OLE DB Destination adapter."
|
Microsoft Press |
May 06, 2010 |
|
| Printed |
Page 164
|
Fact should be Many-to-Many
On page 164, step 3 of Exercise 4 is incorrect.
Change:
"In the Select Relationship Type drop-down list, select Fact, and in the Intermediate Measure Group drop-down list, select Internet Sales Reason."
To:
"In the Select Relationship Type drop-down list, select Many-to-Many, and in the Intermediate Measure Group drop-down list, select Internet Sales Reason."
|
Microsoft Press |
Jul 13, 2010 |
|
| Printed |
Page 193
|
2004 should be 2003
On page 193, the sentence before the last code sample references calendar year 2004 rather than 2003.
Change:
"For example, the following MDX query returns the Internet Sales Amount measure on columns, broken down by product categories or rows, and filtered for calendar year 2004 only."
To:
"For example, the following MDX query returns the Internet Sales Amount measure on columns, broken down by product categories or rows, and filtered for calendar year 2003 only."
|
Microsoft Press |
May 06, 2010 |
|
| Printed |
Page 294
|
"DSCategory" and "DSMonth" should be switched
On page 294, the first sentences of steps 11 and 15 contain the wrong dataset names for the query that follows.
Change:
"11. Type DSCategory as the name of the dataset."
and
"15. Type DSMonth as the name of the dataset."
To:
"11. Type DSMonth as the name of the dataset."
and
"15. Type DSCategory as the name of the dataset."
Microsoft Press is committed to providing informative and accurate
books. All comments and corrections listed above are ready for
inclusion in future printings of this book. If you have a later printing
of this book, it may already contain most or all of the above corrections.
|
Microsoft Press |
Jul 13, 2010 |
|
|
| |
