fbpx

Descendants (MDX)

Returns descendants for the specified member at specified level or distance with different conditions.

Parameters

Name Type Cardinality Default value
member(s)  set-member-expression  one   
level (or distance)  level-numeric-expression  zero-one   
option  SELF|AFTER|BEFORE|BEFORE_AND_AFTER|SELF_AND_AFTER|SELF_AND_BEFORE|SELF_BEFORE_AFTER|LEAVES  zero-one   

Return

set

Description

Descendants function returns:

1) descendants for the specified member at the specified level or distance.
2) descendants for the set members at the specified level or distance.

Optional flags may be used with this function:

1) SELF - returns only members from the specified level or at specified distance.
2) AFTER - returns only members after the specified level or after specified distance.
3) BEFORE - returns only members between the specified member and specified level or distance.
4) BEFORE_AND_AFTER - returns members between the specified member and specified level or distance and members after specified level or distance.
5) SELF_AND_AFTER - returns members after the specified level or after specified distance and specified member itself.
6) SELF_AND_BEFORE - returns members between the specified member and specified level or distance and specified member itself.
7) SELF_BEFORE_AFTER - returns all members from all levels after the level of the specified member including member itself.
8) LEAVES - returns only leaves members between specified member and specified level or distance. Members of the specified level are considered as leaves. If no level is specified returns all the leaves below the member.

If no level or distance is specified, the default value for the level used by the function is determined by calling the Level function for the specified member or by calling the Level function for each member of the specified set.

See Also

Ascendants

Examples

Special Examples (errors, null, ...)

XMLA Properties

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