SQL Server Services 2005 provides you with the business intelligence platform needed to build full-scale, multidimensional databases. MDX is the query language used to extract information from those multidimensional databases. Analysis Services 2005 supports core business functions such as market analysis, budgeting and forecasting.
Written by members of the Analysis Services product team at Microsoft, this timely and authoritative book shows you how to use analysis Services along with SQL Server components like Integration Services along with SQL Server components like Integration Services, Data Mining, and Reporting Services provide comprehensive, end-to-end solutions. Ultimately you'll learn to solve business problems by leveraging all the tools that SQL Server 2005 has to offer.
Chapter 1: Introductionto 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
Chapter 7: Advanced Topics in MDX
Chapter 8: Advanced Dimension Design
Chapter 9: Advanced Cube Design
Chapter 10: extending MDX using External Functions
,etc.