Wrox Home  
Search

Topic: SQL Server

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

Professional SQL Server Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn
ISBN: 978-0-7645-7918-9
Paperback
864 pages
May 2006
This title is out-of-print and not currently available for purchase from this site.


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.

ChapterPageDetailsDatePrint Run
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 (48*395*646 = 12,248,160)

Should read:
For example, aggregation(Month, Product Name, Postal Code) can potentially result in 12 million (48*395*646 = 12,248,160)
11/07/06
Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free