DrilldownMemberTop (MDX)

Drills down members from the first specified set that are present in the second set limiting the number of items in the resulting set to the specified count parameter.


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




The function drills down specified members from the first set (if they are present in the second set).

The number of returned drilled down members will be limited to the count parameter. Only count members from the top (i.e., that have the highest value for the measure) will be appended to the result set.

The optional measure will be applied while sorting members; the default measures is used otherwise.

The optional RECURSIVE flag can be used : in such case the function continues recursively to drill down members.

This function can be used with tuple sets as well.

See Also

DrilldownLevel DrilldownLevelBottom DrilldownLevelTop DrilldownMember DrilldownMemberBottom DrillUpLevel DrillUpMember


Special Examples (errors, null, ...)

XMLA Properties

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