Errata

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

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

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

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

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

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