fbpx

DrilldownLevelTop (MDX)

Drills down members from the specified set for the specified level expression. Only specified count of members from the bottom of the set will be appended to the result.

Parameters

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

Return

set

Description

This function drills down members from the specified set one level below. Only count members from the top (that have the highest value for the specified measure) will be appended to the result set.

If the level is specified only members from the set with this level will be drilled down.

If the measure parameter is specified it will be evaluated to order the members; if not specified the default measure will be used.

See Also

DrilldownLevel DrilldownLevelBottom DrilldownMember DrilldownMemberBottom DrilldownMemberTop DrillUpLevel DrillUpMember

Examples

Special Examples (errors, null, ...)

XMLA Properties

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