Skip to main content

Professional SQL ServerTM Analysis Services 2005 with MDX

Professional SQL ServerTM Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn

ISBN: 978-0-764-57918-9

May 2006

864 pages

Select type: Paperback

Product not available for purchase

Description

  • Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
  • The authors then describe the development processes for building dimensions and cubes from various data sources
  • Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
  • Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions
Acknowledgments.

Introduction.

Part One: Introduction.

Chapter 1: Introduction to Data Warehousing and Analysis Services 2005.

Chapter 2: First Look at Analysis Services 2005.

Chapter 3: Introduction to MDX.

Chapter 4: Working with Data Sources and Data Source Views.

Chapter 5: Dimension Design.

Chapter 6: Cube Design.

Part Two: Advanced Topics.

Chapter 7: Advanced Topics in MDX.

Chapter 8: Advanced Dimension Design.

Chapter 9: Advanced Cube Design.

Chapter 10: Extending MDX using External Functions.

Part Three: Administration, Performance Tuning Integration.

Chapter 11: Updating Your UDM Data.

Chapter 12: Administering Analysis Services.

Chapter 13: Performance Optimization.

Chapter 14: Data Mining.

Chapter 15: Analyzing Cubes using Office Client Components.

Chapter 16: Integration Services.

Part Four: Scenarios.

Chapter 17: Reporting Services.

Chapter 18: Designing Real-Time Cubes.

Chapter 19: Securing Your Data in Analysis Services.

Appendix: MDX Function and Operator Reference.

Index.

What's at the Wiley's web site?
Code downloads for this title are available here.
Download
Code Downloads
Download
What's at the Wiley's web site?
Code downloads for this title are available here.
Code Downloads
Download Code for Chapter 03
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 04
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 05
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 06
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 07
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 08
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 09
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 10
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 11
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 12
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 13
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 14
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 15
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 16
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 17
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 18
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
Download Code for Chapter 19
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
Download
ChapterPageDetailsDatePrint Run
4, 5Error in References
Reference to Figures 1.1 and 1.2 are reversed Page 4 PP 4 and page 5 PP 1
08/08/2007

17Error 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

52Error in Figure Reference
near bottom of page:
reference to Figure 2-87

should be:
Figure 2-37.
04/12/07

38Error in Text
User the credentials of the current user

should be:

Use the credentials of the current user
08/16/2007

67Error 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

70Error 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

72Typo in Text
In the third paragraph, 4th line:

ore

Should be

or
4/15/09

73Error 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

73Error in Table
In the table
product Line Road
Black
should be:
Silver
09/13/07

75Error in Code
in the formula_expression:

SOVLE_ORDER

should be:

SOLVE_ORDER
11/30/2007

80Error 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

83Error 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

99Error in Text
At the end of the first paragraph:
selecting 'With New Named Query'

should be:
selecting 'New named Query'
2/12/07

123Error in Capitalization
2nd line:
Similarly specify English Country Region name

should be:
Similarly specify English Country Region Name
2/14/07

131Error 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

181Typo
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

209Error 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

364Error 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

449Error 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