* 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
1. Introduction.
2. A First Look at SQL Server Analysis Services 2005 Tools.
3. Introduction to MDX Working with Data Sources and Data.
4. Source Views.
5. Creating and Working with Dimensions.
6. Creating and Working with Cubes.
I: ADVANCED TOPICS IN MDX, DIMENSIONS, CUBES, AND EXTENSIONS.
7. Advanced Topics in MDX.
8. Enhancements to Your Dimensions.
9. Enhancements to Your Cubes.
10. Extending MDX User Designed Functions.
II: ADMINISTRATION / INTEGRATION.
11. Administering Analysis Services.
12. Performance Optimization.
13. Data Mining.
14. Introduction to Integration Services.
15. Introduction to Supporting Services.
16. Client Components.
III: SEENARIOS.
17. Designing Real Time Cubes.
18. Securing Your Data in Analysis Services.
19. Updating Your UDM Data.
