fbpx

BottomCount (MDX)

Returns the lowest specified count of tuples. The numeric expression is used to evaluate the tuple value.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
count  numeric-expression  one   
measure  value-expression  zero-one  [Measures].currentMember 

Return

set

Description

Returns the lowest specified count of tuples.

1) A measures expression is specified.

The tuples of the specified set are sorted in ascending order according to their cell values. Then, the specified number of tuples with the lowest values are returned. Note that empty cells are not ignored and are considered as zero values.

2) A measures expression is not specified.

The BottomCount(set,count,measure) function is then equivalent to the Head(Order(set,measure,BASC),count) function.

See Also

TopCount DrilldownMemberBottom Tail

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.