The MDX Descendants function returns the set of descendants of a member at a specified level or distance, optionally including or excluding descendants in other levels.
This function returns the members in hierarchized order; for example, parent members are followed by child members.

Syntax

Descendants ( member , [{ layer | index }[, Desc_flags ]])

Arguments

member

The member for which descendants are sought.

layer

Optional. Layer specification indicating the depth of the descendants to return.

index

Optional. A number of hierarchical steps down from member, locating the descendants you want returned.

Desc_flags

Optional. Keywords which further indicate which members to return. These keywords are available only if layer or index is specified.

Notes

Examples

select
members(measure) on 1,
Descendants([starting date].[ALL].[2021], [starting date].[quarter]) on 0
from [logistics.test]
where
(Goods.[ALL].[household appliances].[television], Transport.[ALL].[ocean freight], [starting region].[ALL].[Europe].[UK], [ending region].[ALL].[Europe].[Italy], [starting date].[ALL].[2021].[Q2].[M4], [completion date].[ALL].[2020].[Q1].[M1]) ;

	Q1	Q2	Q3	Q4
cost	0	12	0	0
income	0	266.64	0	0
quantity	0	3006009	0	0