Fast Track to MDX

• Main Authors: Whitehorn, Mark (Author), Zare, Robert (Author), Pasumansky, Mosha (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: London : Springer London : Imprint: Springer, 2006.
• Edition: Second Edition.
• Subjects: Computer science.; Programming languages (Electronic computers).; Database management.; Computer Science.; Programming Languages, Compilers, Interpreters.; Database Management.

OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to re...

Table of Contents:

• 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.