Skip to main content
  • Book
  • © 2006

Fast Track to MDX

  • Co-written with two members of Microsoft's Analysis Services team

  • One of the first books available on MDX to include the latest release of Analysis Services

  • Includes supplementary material: sn.pub/extras

Buying options

eBook USD 69.99
Price excludes VAT (USA)
  • ISBN: 978-1-84628-182-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 89.99
Price excludes VAT (USA)

This is a preview of subscription content, access via your institution.

Table of contents (21 chapters)

  1. Front Matter

    Pages i-xxv
  2. Readme.doc — definitions you need to know

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 1-28
  3. How MDX is used

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 29-34
  4. MDX queries

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 35-52
  5. MDX syntax

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 53-57
  6. MDX expressions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 58-79
  7. Navigating the hierarchy

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 80-98
  8. Snapshot data analysis

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 99-109
  9. Moving averages

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 110-118
  10. Filters

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 119-127
  11. Setting the default member

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 128-137
  12. Member properties and dimension security

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 138-150
  13. Distinct Count

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 151-155
  14. Parent-Child dimensions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 156-161
  15. Advanced data modeling — Custom Order, Custom Rollup, Custom Members

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 162-185
  16. Further advanced data modeling techniques

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 186-200
  17. Actions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 201-211
  18. Server side color coding

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 212-219
  19. More about querying

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 220-250
  20. More MDX in general

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 251-262

About this book

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 release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions).
Fast Track to MDX gives you all the necessary background to let you to 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 knowledge of database systems and 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.
Second Edition – It was the clarity, precision and sheer readability of the first edition that made it a best-seller. With that firmly in mind the authors have left the original 18 chapters intact (apart from minor updates); meaning that the second edition remains the best introduction to MDX that is available. What they have done is to add three brand new chapters. These introduce the topic of recursion in MDX, walk the reader through the process of creating recursive expressions and finally demonstrate how recursion can be used to effectively solve a series of business problems.
Forward by Amir Netz, Product Unit Manager, SQL Server – Analysis Services at Microsoft.

Keywords

  • Data Warehousing
  • OLAP
  • Processing
  • Rack
  • SQL
  • SQL Server
  • data analysis
  • database
  • database systems
  • relational database

Authors and Affiliations

  • University College Worcester, Worcester, UK

    Mark Whitehorn

  • Microsoft Corporation, Redmond, USA

    Robert Zare, Mosha Pasumansky

Bibliographic Information

  • Book Title: Fast Track to MDX

  • Authors: Mark Whitehorn, Robert Zare, Mosha Pasumansky

  • DOI: https://doi.org/10.1007/1-84628-182-2

  • Publisher: Springer London

  • eBook Packages: Computer Science, Computer Science (R0)

  • Copyright Information: Springer-Verlag London 2006

  • Softcover ISBN: 978-1-84628-174-7

  • eBook ISBN: 978-1-84628-182-2

  • Edition Number: 2

  • Number of Pages: XXVI, 310

  • Number of Illustrations: 199 b/w illustrations

  • Topics: Compilers and Interpreters, Database Management

Buying options

eBook USD 69.99
Price excludes VAT (USA)
  • ISBN: 978-1-84628-182-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 89.99
Price excludes VAT (USA)