|
Professional SQL Server Analysis Services 2005 with MDX
* 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.
|
