Table of Contents

Introduction.

Chapter 1: A First Introduction to MDX.

Chapter 2: Introduction to MDX Calculated Members and Named Sets.

Chapter 3: Common Calculations and Selections in MDX.

Chapter 4: MDX Query Context and Execution.

Chapter 5: Named Sets and Set Aliases.

Chapter 6: Sorting and Ranking in MDX.

Chapter 7: Advanced MDX Application Topics.

Chapter 8: Using the Attribute Data Model of Microsoft Analysis Services.

Chapter 9: Using Attribute Dimensions and Member Properties in Hyperion Essbase.

Chapter 10: Extending MDX through External Functions.

Chapter 11: Changing the Cube and Dimension Environment through MDX.

Chapter 12: The Many Ways to Calculate in Microsoft Analysis Services.

Chapter 13: MDX Scripting in Analysis Services 2005.

Chapter 14: Enriching the Client Interaction.

Chapter 15: Client Programming Basics.

Chapter 16: Optimizing MDX.

Chapter 17: Working with Local Cubes.

Appendix A: MDX Function and Operator Reference.

Appendix B: Connection Parameters That Affect MDX.

Appendix C: Intrinsic Cell and Member Properties.

Appendix D: Format String Codes.

Index.