Professional SQL Server Analysis Services 2005 with MDX

ISBN: 978-0-7645-7918-9

Paperback

864 pages

May 2006

Professional SQL Server Analysis Services 2005 with MDX (0764579185) cover image

This product is not currently available for purchase from this website.
For customer care, special sales, or to find your rep, please visit our Contact Us page.

Other Available Formats: E-book

< >

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

Page	Details	Date
4, 5	Error in References Reference to Figures 1.1 and 1.2 are reversed Page 4 PP 4 and page 5 PP 1	08/08/2007
17	Error in Reference paragraph ends with: you learn more about proactive caching in Chapter 17 Reference to Chapter 17 should be: Chapter 18	7/021/06
52	Error in Figure Reference near bottom of page: reference to Figure 2-87 should be: Figure 2-37.	04/12/07
38	Error in Text User the credentials of the current user should be: Use the credentials of the current user	08/16/2007
67	Error in Figure 1. select measures.[Internet Sales Amount] on columns from [Adventure Works] where ([Date].[Calendar].[Calendar Quarter].&[2003]&[1], [product].[product line].[Mountain], [Customer].[Country].[Australia] ) Note: Due to changes in the sample shipped with the product you will not see the exact values shown in Figure 3-4. Please use Figure 3-4 as an illustration to understand MDX concepts.	01/12/07
70	Error in Reference The top of the page references duplicate tuples; the example, however, contains no duplicat because Australia is misspelled as Austrailia.	01/04/07
72	Typo in Text In the third paragraph, 4th line: ore Should be or	4/15/09
73	Error in Text Page 73, code at bottom of page starts with: text reads: SELECT Measures.[Sales] ON COLUMS should be: SELECT Measures.[Sales] on COLUMNS	11/03/06
73	Error in Table In the table product Line Road Black should be: Silver	09/13/07
75	Error in Code in the formula_expression: SOVLE_ORDER should be: SOLVE_ORDER	11/30/2007
80	Error in Example Example 2, the cross product of the two sets should be: { ([Customer].[Country].[Australia], [Product].[Product Line].[Mountain]), ([Customer].[Country].[Australia], [Product].[Product Line].[Road]), ([Customer].[Country].[Canada], [Product].[Product Line].[Mountain]), ([Customer].[Country].[Canada], [Product].[Product Line].[Road]) }	01/05/07
83	Error in Text Under the heading Set Functions, the second sentence: The take sets are arguments and often... should read: They take sets as arguments and often...	7/24/06
99	Error in Text At the end of the first paragraph: selecting 'With New Named Query' should be: selecting 'New named Query'	2/12/07
123	Error in Capitalization 2nd line: Similarly specify English Country Region name should be: Similarly specify English Country Region Name	2/14/07
131	Error in Text Page 131 - Step 2 Text reads: Click the KeyColumns property value(the three dots button). This action launches the DataItem Collector dialog. Should be: Click the KeyColumns property value(the three dots button). This action launches the DataItem Collection dialog.	11/06/06
181	Typo Half way down second paragraph it reads: "There is a new flow model that replaces explicit manipulation of solve order and calculation pass precedence which were used for ordering calculations is Analysis Services 2000" should be: "There is a new flow model that replaces explicit manipulation of solve order and calculation pass precedence which were used for ordering calculations in Analysis Services 2000" (in case you don't see a difference the last 'is' of the first sentence should be 'in').	10/16/06
209	Error in Text Chapter 8 page 209 - First Paragraph Text reads: Finally, you are introduced to dimension writeback, which is a way to make changes to dimension members for "what" if analysis. Should be: Finally, you are introduced to dimension writeback, which is a way to make changes to dimension members for "what if" analysis. OR ("what-if")	10/27/06
364	Error in MDX query First MDX query on the page: UPDATE CUBE [Adventure Works DW] SET ( [WB Employee].[Manager].&[290] , [WB Period].[Period].&[20043]) = 1000; should be: UPDATE CUBE [Adventure Works DW] SET ( [WB Employee].[Manager].&[291] , [WB Period].[Period].&[20043]) = 1000;	09/14/07
449	Error in Text Page 449, Paragraph 3: Text reads: For example, aggregation(Month, Subcategory, Postal Code) will potentially result in 12 million (48395646 = 12,248,160) Should read: For example, aggregation(Month, Product Name, Postal Code) can potentially result in 12 million (48395646 = 12,248,160)	11/07/06