Combine BottomCount() with Other MDX Functions to Add Sophistication

In this article, we will extend our examination of the BottomCount() function to illustrate somewhat more sophisticated uses. We will dive right into a practical scenario, where we will further evolve our understanding of the operation of BottomCount() through:

• Defining an illustrative business need as posed to us by hypothetical groups of information consumers;
• Discussing the need from the perspective of MDX in general, and the BottomCount() function in particular;
• Constructing, in a step-by-step manner, a query to ultimately meet the expressed requirement using combinations of BottomCount() and other MDX functions we have explored in articles of the series;
• Discuss the syntax contained within the solutions we construct for the information consumers;
• Briefly discuss the results datasets we obtain in executing the MDX queries we construct.