fbpx

DrilldownMember (MDX)

Drills down the members in a specified set that are present in a second specified set.

Parameters

Name Type Cardinality Default value
set-1  set-expression     
set-2  set-expression     
  RECURSIVE     

Return

set

Description

The function takes two sets as parameters and constructs a new set from the first set including children of the elements from the second set that are present in the first set.

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 DrilldownMemberBottom DrilldownMemberTop DrillUpLevel DrillUpMember

Examples

Special Examples (errors, null, ...)

XMLA Properties

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