PASS Database Days 2013

17th - 19th April 2013Trafo Conference Centre Baden, Switzerland

Swiss PASS Chapter

Introduction to MDX

Chris Webb

Principal Consultant, Crossjoin Consulting



This session will provide an introduction to the MDX language used by SQL Server Analysis Services, and will show you how to write common types of query and calculation. Previous experience of SSAS is useful, but no previous MDX knowledge is necessary.


Topics covered include:

  • MDX basic theory - dimensions, hierarchies, levels, members, tuples and sets
  • MDX SELECT statements
  • Basic calculated members
  • MDX functions that return sets and members
  • MDX functions that return numeric values
  • The CurrentMember() function
  • Implementing common calculations such as previous period growths and market shares


About the speaker:

Chris Webb

Related videos