Multidimensional Expressions (MDX)

This MDX or multidimensional expressions page shows the list of available functions to work with the cube. For the query demonstration, we use the Adventure Works cube.

MDX Functions

  1. Ascendants
  2. AVG
  3. BottomCount
  4. BottomPercent
  5. BottomSum
  6. Children
  7. ClosingPeriod
  8. Cousin
  9. FirstChild
  10. FirstSibling
  11. Head
  12. LastChild
  13. LastSibling
  14. LastPeriods
  15. Lag
  16. Lead
  17. NextMember
  18. Non Empty
  19. NonEmpty Function
  20. OpeningPeriod
  21. ParallelPeriod
  22. Parent
  23. PeriodsToDate
  24. PrevMember
  25. Siblings
  26. Tail
  27. TopCount
  28. TopPercent
  29. TopSum

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.

Comments are closed.