|FAST TRACK TO MDX: Second edition
(for SQL Server 2000)
you need to write useful, powerful MDX
This second edition is essentially the same as the first EXCEPT
we have added three chapters which introduce the concept of
It seems worth stressing that this book is still about MDX in SQL
Server 2000 not 2005. We are working on a book for 2005 but it
is still a work in progress.
The publisher's blurb says:
From two key members of Microsoft's Analysis Services team: Mosha
Pasumansky was the developer in charge for the first implementation
of MDX in the Microsoft OLAP Services 7.0 product and is currently
working on the next version of Microsoft Analysis Services. No-one
knows more about MDX. Robert Zare is Program Manager for Analysis
Services at Microsoft. It was his inspirational talks on MDX, given
at TechEd, that led to this book being written.
By the best-selling author of Inside Relational Databases, DB2
for Windows NT Fast and Accessible Access 200: Mark Whitehorn, co-author
of Inside Relational Databases, is renowned for the clarity of his
technical writing. He encapsulates the detailed knowledge of the
other two authors into an approachable and highly readable book.
OLAP (On-Line Analytical Processing) is the most powerful BI (Business
Intelligence) tool currently available and Microsoft's Analysis
Manager makes OLAP cubes extremely easy to build and deploy. However,
in order to leverage the real power of OLAP, in order to solve real-life
business problems, you need to understand and use the language that
both controls the cubes and allows them to be queried. That language
is MDX (Multi Dimensional eXpressions).
- 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
- Setting the default member
- Member properties and Dimension security
- Distinct Count
- Parent-Child dimensions
- Advanced data modelling - Custom Order, Custom Rollup, Custom Members
- Further advanced data modelling techniques
- Server side colour coding
- More about querying
- More MDX in general
- Recursion in MDX
- Query performance and NonEmptyCrossJoin
In order to write effective MDX you need:
- a clear understanding of dimensional structuring - hierarchies,
dimensions, measures, members, tuples and sets.
- a knowledge of the syntax and functions specific to MDX.
This book covers both areas in detail and gives you all the necessary
groundwork to enable you to write useful, powerful MDX and also
introduces the most frequently used MDX functions and constructs.