Further Combination of BottomCount() with Other MDX Functions

In this article, we will conclude our examination of the BottomCount() function, illustrating another somewhat sophisticated use through a compounding of the function with additional MDX functions. Following our approach in Combine BottomCount() with Other MDX Functions to Add Sophistication, we will expose a practical scenario, where we will further evolve our understanding of the operation of BottomCount() through:

• Defining another illustrative business need as posed to us by hypothetical groups of information consumers;
• Discussing the need, once again, from the perspective of MDX in general, and the BottomCount() function in particular;
• Constructing, again, 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;
• Discussion of the syntax contained within the solutions we construct for the information consumers;
• Brief discussion of the results datasets we obtain in executing the MDX queries we construct throughout the steps of our practice session.