DeepSee MDX Reference
BOTTOMCOUNT
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Sorts a set and returns a subset from its lower-valued end, given a desired element count.
Returned Type
This function returns a set of members or tuples, depending on the set used.
Syntax and Details
BOTTOMCOUNT(set_expression, element_count, optional_ordering_expression)
Where:
Example
First consider the following query and the results it returns:
SELECT MEASURES.[%COUNT] ON 0, 
BOTTOMCOUNT(birthd.decade.MEMBERS, 100, MEASURES.[%COUNT]) ON 1 
FROM patients
                             Patient Count
 1 1910s                                 71
 2 2010s                                155
 3 1920s                                223
 4 1930s                                572
 5 1940s                                683
 6 1950s                              1,030
 7 1980s                              1,400
 8 1990s                              1,413
 9 2000s                              1,433
10 1960s                              1,500
11 1970s                              1,520
Because count_expression is greater than the number of members, all members are returned. The members are sorted in ascending order according to the value of the %COUNT measure.
Next, consider a similar query, using count_expression equal to 3:
SELECT MEASURES.[%COUNT] ON 0, 
BOTTOMCOUNT(birthd.decade.MEMBERS, 3, MEASURES.[%COUNT]) ON 1 
FROM patients
                             Patient Count
1 1910s                                  71
2 2010s                                 155
3 1920s                                 223
This query selects three members from the lower-valued end of the set.
See Also