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