SQL Server's Developer's Guide to OLAP with Analysis Services

by Mike Gunderloy; Tim Sneath

• ISBN13: 9780782129571
• ISBN10: 0782129579
• Edition: CD
• Format: Paperback
• Copyright: 2001-01-01
• Publisher: Sybex

Summary

The Skills You Need to Develop OLAP Solutions with SQL Server 2000 This one-of-a-kind book teaches you everything you need to know to use Microsoft's Analysis Services software to build, implement, and manage effective OLAP solutions. Expert advice and in-depth explanations combine to help you and your company take full advantage of the affordable power of SQL Server's built-in OLAP functionality. Coverage Includes: Analyzing large volumes of data effectively with Analysis Services Architecting and designing data analysis applications Querying OLAP data using MDX Programming applications using ADO/MD Managing Analysis Services servers with DSO Building data mining solutions with Analysis Services Using English Query for natural language querying of OLAP data Choosing appropriate client tools for exploring OLAP data Using the PivotTable Service for client-side data analysis Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Introduction	xix
OLAP and Data Mining Concepts	1	(12)
Analysis Services Architecture	13	(26)
Analysis Services Lifecycle	39	(22)
Using Analysis Services	61	(38)
Advanced Analysis Services	99	(40)
Querying Analysis Services with MDX	139	(48)
Building Analysis Services Applications with ADO/MD Part I: Cube Schema Objects	187	(52)
Building OLAP Services Applications with ADO/MD Part II: Query Retrieval Objects	239	(30)
Advanced Usage of the PivotTable Service	269	(32)
Managing an Analysis Services Environment Using DSO	301	(46)
Building Data Mining Solutions with Analysis Services	347	(38)
Supporting Natural Language Queries with English Query	385	(24)
Appendix A: MDX Reference	409	(20)
Appendix B: ADO/MD Object Model	429	(4)
Appendix C: DSO Object Model	433	(4)
Appendix D: English Query Object Model	437	(4)
Index	441