MDX Solutions: SORTING using ORDER and TOPCOUNT functions

As with most applications there are many different ways to complete a task and sorting in MDX is no exception. Furthermore, Analysis Services utilization of hierarchies further complicates the method and implementation of sorting routines. SSAS actually has several potential layers of sorting, we can set the sorting at the enter dimension level or force sorting during http://mikescarpetconnection.com/hdvertiglideclosed/ query run time. For dimension attributes, we can actually set the Order By property in SSDT to either a dimension attribute Name or a Key as displayed below for the Product attribute under the DimProduct dimension. Additionally, the sort order defined on the dimension attribute property screen can only be the enter name or the key and is always in ascending order. Read more MDX Solutions: SORTING using ORDER and TOPCOUNT functions