Full Description
"Fast Track to MDX" gives you all the necessary background to let you write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems. Mark Whitehorn, co-author of the best-selling "Inside Relational Databases", is renowned for his enthusiasm towards data handling and for the lucidity of his writing. Robert Zare is a program manager for Analysis Services at Microsoft: his inspiring talks on MDX sowed the seeds from which this book grew. Mosha Pasumansky was one of the authors of the OLEDB for OLAP specification that defined the MDX language and later he was the developer in charge of the first implementation of MDX in the Microsoft OLAP Services 7.0 product. He is currently the development lead of the Analysis Services engine team. A CD-ROM containing examples from within the book, and a time-limited version of ProClarity, is included.
Contents
Forward * Introduction * Readme.doc - Definitions You Need to Know * How MDX is Used * MDX Queries * MDX Syntax * MDX Expressions * Navigating the Hierarchy * Snapshot Data Analysis * Moving Averages * Filters * Setting the Default Member * Member Properties and Dimension Security * Distinct Count * Parent-Child Dimensions * Advanced Data Modeling - Custom Order, Custom Rollup, Custom Members * Further Advanced Data Modeling Techniques - Actions * Server Side Color Coding * More About Querying * Appendix 1: Sample Files * Appendix 2: ProClarity * Index
