BottomCount

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.

Syntax

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.

Example

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