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:
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Chapter 1: OLAP and Data Mining Concepts.
Chapter 2: Analysis Services Architecture.
Chapter 3: Analysis Services Lifecycle.
Chapter 4: Using Analysis Services.
Chapter 5: Advanced Analysis Services.
Chapter 6: Querying Analysis Services with MDX.
Chapter 7: Building Analysis Services Applications with ADO/MD Part I: Cube Schema Objects.
Chapter 8: Building OLAP Services Applications with ADO/MD Part II: Query Retrieval Objects.
Chapter 9: Advanced Usage of the PivotTable Service.
Chapter 10: Managing an Analysis Services Environment Using DSO.
Chapter 11: Building Data Mining Solutions with Analysis Services.
Chapter 12: Supporting Natural Language Queries with English Query.
Appendix A: MDX Reference.
Appendix B: ADO/MD Object Model.
Appendix C: DSO Object Model.
Appendix D: English Query Object Model.
Index.
Overview
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 ...