fbpx

DrilldownLevel (MDX)

Drills down one level members from the specified set.

Parameters

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

Return

set

Description

The function drills down members from the specified set one level below; it takes one of two optional parameters: level or index.

If level was specified only the members from the set for this level will be drilled down.

The index parameter (zero-base) can be used when DrilldownLevel applies to a set of tuples, instead of a set of members. The index tells which member (or hierarchy) of the tuples should be used to perform the drilled down.

See Also

DrilldownLevelBottom DrilldownLevelTop DrilldownMember DrilldownMemberBottom DrilldownMemberTop DrillUpLevel DrillUpMember

Examples

Special Examples (errors, null, ...)

XMLA Properties

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