MDX Solutions
With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
Chapter One
Sorting and Ranking
in MDX
A very common requirement for analytical applications is providing sorted
and ranked views of data. Users are always interested in Top-10 lists, and often
in seeing who or what was #1 last month or year. We'll cover the basics of sorting
and ranking in this chapter, and also look at some ins and outs for more
advanced kinds of sorting and ranking calculations.
Functions used in this chapter are Order(), Hierarchize(), Top-Count(),
BottomCount(), TopSum(), BottomSum(), TopPercent(),
BottomPercent(), YTD(), CoalesceEmpty(), Rank(), ParallelPeriod(),
Generate(), Ancestor(), Descendants(), .Properties(),
DrillDownLevelTop().
The Function ... read full excerpt from MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase ebook
