This up-to-date user guide covers the major new release of Microsoft OLAP Services, now called Microsoft Analysis Services--the technology that made online data analysis widely available for application developers. A sequel to our successful Microsoft OLAP Solutions, this book provides detailed instructions for installing, using, and managing Microsoft Analysis Services as well as integrating it with other Microsoft data warehouse tools. Coverage of new features includes data mining in analysis services, working with the analysis manager interface, scalability features in analysis servers, and allowing clients to analyze information while disconnected from the server.

Contents

• Introduction
• Acknowledgments
• Chapter 1 A First Introduction to MDX
• Chapter 2 MDX in More Detail
• Chapter 3 MDX in Use
• Chapter 4 Advanced MDX Application Topics
• Chapter 5 MDX Context and Execution
• Chapter 6 The Many Ways to Calculate in Microsoft Analysis Services
• Chapter 7 Extending MDX Through External Functions
• Chapter 8 Building Queries in MDX
• Chapter 9 Advanced Operations and Commands-Drill-Through and Actions
• Chapter 10 Changing the Cube and Dimension Environment Through MDX
• Chapter 11 Advanced Applications in Cube Design
• Chapter 12 Client Programming Basics
• Chapter 13 Working With Local Cubes
• Chapter 14 Optimizing MDX
• Appendix A MDX Function and Operator Reference
• Appendix B Connection Parameter That Affect MDX
• Appendix C Intrinsic Cell and Member Properties
• Appendix D Format String Codes
• Index