Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Errata for Microsoft® SQL Server™ 2005 Analysis Services Step by Step




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
Printed
Page xii

Missing space in command path On page xii, the first sentence of step 5 reads: "Click the Start button, click Run, and then type C:Documents and Settings\My DocumentsMicrosoftPressas2005sbsSetupRestoreRestore_databases.cmd in the Open box." It should read: "Click the Start button, click Run, and then type C:Documents and Settings\My DocumentsMicrosoft Pressas2005sbsSetupRestoreRestore_databases.cmd in the Open box."

Microsoft Press  May 06, 2010 
Printed
Page 72

DimProductCategory should be DimProductSubcategory On page 72, Step 9 contains an incorrect attribute name. Change: "Select the check box to the left of Dim Product Subcategory, and then, in the same row, click dbo.DimProductCategory.EnglishProductSubcategoryName in the Attribute Name Column drop-down list." To: "Select the check box to the left of Dim Product Subcategory, and then, in the same row, click dbo.DimProductSubcategory.EnglishProductSubcategoryName in the Attribute Name Column drop-down list."

Microsoft Press  Jul 13, 2010 
Printed
Page 231

The first sentence under "Localizing Cubes" needs to be removed On page 231, the first sentence under the heading "Localizing Cubes" needs to be removed and the word "also" needs to be removed from the second sentence. Change: "In the previous procedures, you implemented currency conversion to accommodate multiple currency valuations for Adventure Works, a global company. You can also apply translations to a cube to display the labels on rows and columns in different languages. You can even implement translations to reflect members of a dimension by language. Together, currency conversion and translation enable you to provide users with an analytical solution that displays their local currency and language." To: "You can apply translations to a cube to display the labels on rows and columns in different languages. You can even implement translations to reflect members of a dimension by language. Together, currency conversion and translation enable you to provide users with an analytical solution that displays their local currency and language."

Microsoft Press  May 06, 2010 
Printed
Page 297

Nine partitions listed rather than eight On page 297, the third sentence of the second paragraph of step 2 reads: "In the SSAS cube, you can see there are nine partitions— Reseller Sales, Internet Sales, Product Forecast, Inventory, Distinct Count, Finance, Fact Account Manager, Currency Exchange Rates, and Units Forecast." It should read: "In the SSAS cube, you can see there are eight partitions— Reseller Sales, Internet Sales, Product Forecast, Inventory, Distinct Count, Finance, Fact Account Manager, and Units Forecast."

Microsoft Press  Jul 13, 2010 
Printed
Page 308

Column and row axes switched in step 6 On page 308, step 6 reads: "In the Cube Designer for the ROLAP cube, click the Browser tab, drag the Measures object to the Totals area of the grid, expand Sales Territory and drag Sales Territory Country to the columns axis, and then expand Order Date and drag Order Date.Year to the rows axis." It should read: "In the Cube Designer for the ROLAP cube, click the Browser tab, drag the Measures object to the Totals area of the grid, expand Sales Territory and drag Sales Territory Country to the rows axis, and then expand Order Date and drag Order Date.Year to the columns axis."

Microsoft Press  May 06, 2010 
Printed
Page 327

Additional information needed On page 327, the 2nd sentence under point 5 is missing the word "record". Change: "This SQL script adds one more to the FactResellerSales table to record a sale in Mexico." To: "This SQL script adds one more record to the FactResellerSales table to record a sale in Mexico."

Microsoft Press  Jul 13, 2010 
Printed
Page 327

"Sales Territory" should be "Sales Territory Country" On page 327, the 1st sentence in Step 7 contains an inaccuracy. Change: "In SQL Server Management Studio, browse the MOLAP cube in the Working with Storage database by placing Sales Territory on rows and Measures in the totals area." To: "In SQL Server Management Studio, browse the MOLAP cube in the Working with Storage database by placing Sales Territory Country on rows and Measures in the totals area."

Microsoft Press  May 06, 2010 
Printed
Page 355

Last line in XMLA script is not code On page 355, the last line in the XMLA script is an instruction to the reader and not a line of code. The following line needs to be removed from the grey code box and placed below it: "Click the Execute button in the query window."

Microsoft Press  Jul 13, 2010 
Printed
Page 366

"SSAS Step by Step" should be "Managing Deployment" On page 366, the sentence directly above step 1 references an incorrect database. Change: "In this procedure, you’ll restore the backup of the SSAS Step by Step database." To: "In this procedure, you’ll restore the backup of the Managing Deployment database."

Microsoft Press  May 06, 2010 
Printed
Page 367

"SSAS Step by Step" should be "Managing Deployment" On page 367, the last sentence in Step 5 contains a reference to an incorrect database. Change: "You should see the new database, My Restored Database, appear in the list of available databases in addition to the original database, SSAS Step by Step." To: "You should see the new database, My Restored Database, appear in the list of available databases in addition to the original database, Managing Deployment." 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.The print number of the book is located on the copyright page in the form of a string of numbers. For example: "2 3 4 5 6 7 8 0 QWT 9 8 76 5 4". The first number in the string is the the print number. In this example, the print number is 2.

Microsoft Press  Jul 13, 2010