Skip to main content
SpringerLink
Log in
Download book PDF
Book cover
  • Book
  • © 2006

Fast Track to MDX

Authors:

  1. Mark Whitehorn

    1. University College Worcester, Worcester, UK

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Robert Zare

    1. Microsoft Corporation, Redmond, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Mosha Pasumansky

    1. Microsoft Corporation, Redmond, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • 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

Sections

Buy it now

Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Table of contents (21 chapters)

  1. Front Matter

    Pages i-xxv
    PDF

  2. Readme.doc — definitions you need to know

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 1-28
    PDF

  3. How MDX is used

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 29-34
    PDF

  4. MDX queries

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 35-52
    PDF

  5. MDX syntax

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 53-57
    PDF

  6. MDX expressions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 58-79
    PDF

  7. Navigating the hierarchy

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 80-98
    PDF

  8. Snapshot data analysis

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 99-109
    PDF

  9. Moving averages

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 110-118
    PDF

  10. Filters

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 119-127
    PDF

  11. Setting the default member

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 128-137
    PDF

  12. Member properties and dimension security

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 138-150
    PDF

  13. Distinct Count

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 151-155
    PDF

  14. Parent-Child dimensions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 156-161
    PDF

  15. Advanced data modeling — Custom Order, Custom Rollup, Custom Members

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 162-185
    PDF

  16. Further advanced data modeling techniques

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 186-200
    PDF

  17. Actions

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 201-211
    PDF

  18. Server side color coding

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 212-219
    PDF

  19. More about querying

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 220-250
    PDF

  20. More MDX in general

    • Mark Whitehorn, Robert Zare, Mosha Pasumansky
    Pages 251-262
    PDF
Back to top

About this book

IloveBusinessIntelligence.IloveBIbecauseitisallaboutbecomingbetter. BI is all about empowering us with knowledge and that knowledge is the power to realize our full potential. As Zorge the spy said, “knowledge is power”, and who doesn’t love to have the power to know, to understand and to make intelligent decision? I do. Since the dawn of the modern information system it was obvious that the information accumulated in the machine is wasted if there is no way to analyze it and learn from it. From as early as the 1950s, data analysis systems and, later, decision support systems were designed, developed anddeployedwiththatintent.However,onlyinthelastdecadehavethese systems become both reasonably affordable and mainstream and their business impact indisputable. The last decade has also seen the emergence of OLAP as the centerpiece of the BI technologies. The OLAP multidimensional databases combine incredible performance with unsurpassed analytical power and, in my opinion, are the foundation of the BI platform. While the performance differences between the multidimensional da- bases and the traditional relational databases are very significant, Moore’s law, which states that the hardware computing power doubles every 18 months, renders this advantage of the OLAP databases temporary. Sooner or later, the raw computing power of the common server machines will be sufficient to provide the performance needed for sophisticated analysis even when the data is stored in a relational database.
Back to top

Keywords

Back to top

Authors and Affiliations

  • University College Worcester, Worcester, UK

    Mark Whitehorn

  • Microsoft Corporation, Redmond, USA

    Robert Zare, Mosha Pasumansky

Back to top

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-7Published: 12 December 2005

  • eBook ISBN: 978-1-84628-182-2Published: 29 December 2007

  • Edition Number: 2

  • Number of Pages: XXVI, 310

  • Number of Illustrations: 199 b/w illustrations

  • Topics: Programming Languages, Compilers, Interpreters, Database Management

Back to top

Publish with us

Policies and ethics

Back to top
Download book PDF

Buy it now

Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Search

Navigation