Having covered the bulk of the MDX material you would need in a day-to-day basis, this video adds some additional ideas on sorting and ordering. Scott Whigham discusses the Order function, TopCount and BottomCount, and how to break hierarchies with the Order By.

Highlights from this video:

- How does SSAS treat a sort on a user-defined hierarchy?
- Sorting according to ascending and descending
- Attribute hierarchy
- Parents, children, and grandchildren

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…