Returns a set of n elements ordered from smallest to largest, optionally based on an evaluation.
This function ignores tuples that resulted in missing values after evaluating numeric value expression.
BottomCount ( set, index [,numeric_value_expression ] )
set | The set from which to select the bottom n elements. |
index | The number of elements to include in the set (n). |
numeric_value_expression | Optional. An expression further defining the selection criteria. |
The following expression
Bottomcount ( [Product].levels(0).members, 10, ( [Sales], [Actual] ) )
returns the set:
{ [200-40], [100-30], [400-30], [300-20], [200-30], [100-20], [100-20], [400-20], [400-10], [300-30] }
Therefore, the following query
SELECT {[Year].levels(1).members} ON COLUMNS, BottomCount ( [Product].levels(0).members, 10, ( [Sales], [Actual] ) ) ON ROWS FROM Sample.Basic WHERE ( [Sales], [Actual] )
returns the grid:
Qtr1 | Qtr2 | Qtr3 | Qtr4 | |
---|---|---|---|---|
200-40 | 2807 | 2922 | 2756 | 3265 |
100-30 | 3187 | 3182 | 3189 | 3283 |
400-30 | 3763 | 3962 | 3995 | 4041 |
300-20 | 4248 | 4638 | 4556 | 4038 |
200-30 | 4440 | 4562 | 4362 | 4195 |
100-20 | 7276 | 7957 | 8057 | 7179 |
7276 | 7957 | 8057 | 7179 | |
400-20 | 7771 | 8332 | 8557 | 8010 |
400-10 | 8614 | 9061 | 9527 | 8957 |
300-30 | 8969 | 9105 | 9553 | 9342 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |