fbpx

TopCount (MDX)

Returns the highest specified count of tuples. The numeric expression is used to evaluate the tuple values.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
count  numeric-expression  one 
measure  value-expression  zero-one   

Return

set

Description

Returns the highest specified count of tuples.

1) A measures expression is specified.

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

2) A measures expression is not specified.

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

See Also

BottomCount TopPercent TopSum Head DrilldownMemberTop

Examples

Special Examples (errors, null, ...)

XMLA Properties

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