Read more
* When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
List of contents
Introduction.
Part I: Introduction.
Chapter 1: Introduction to Data Warehousing and SQL Server 2008 Analysis Services.
Chapter 2: First Look at Analysis Services 2008.
Chapter 3: Introduction to MDX.
Chapter 4: Working with Data Sources and Data Source Views.
Chapter 5: Dimension Design.
Chapter 6: Cube Design.
Chapter 7: Administering Analysis Services.
Part II: Advanced Topics.
Chapter 8: Advanced Dimension Design.
Chapter 9: Advanced Cube Design.
Chapter 10: Advanced Topics in MDX.
Chapter 11: Extending MDX Using External Functions.
Chapter 12: Data Writeback.
Part III: Advanced Administration and Performance Optimization.
Chapter 13: Programmatic and Advanced Administration.
Chapter 14: Designing for Performance.
Chapter 15: Analyzing and Optimizing Query Performance.
Part IV: Integration with Microsoft Products.
Chapter 16: Data Mining.
Chapter 17: Analyzing Cubes Using Microsoft Office Components.
Chapter 18: Using Data Mining with Office 2007.
Chapter 19: Integration Services.
Chapter 20: Reporting Services.
Part V: Scenarios.
Chapter 21: Designing Real-Time Cubes.
Chapter 22: Securing Your Data in Analysis Services.
Chapter 23: Inventory Scenarios.
Chapter 24: Financial Scenarios.
Chapter 25: Web Analytics.
Appendix A: MDX Functions.
Index.