Descendants

Returns the set of descendants of a member at a specified level, optionally including or excluding descendants in other levels.

Returns the set of descendants of a member at a specific distance away in the hierarchy, optionally including or excluding descendants in other levels.

These are the values for Desc_flags:

  • SELF
  • AFTER
  • BEFORE
  • BEFORE_AND_AFTER
  • SELF_AND_AFTER
  • SELF_AND_BEFORE
  • SELF_BEFORE_AFTER
  • LEAVES

Syntax 1

«Set» Descendants («Member», «Level»[, «Desc_flags»])

Syntax 2

«Set» Descendants («Member», «Numeric Expression»[, «Desc_flags»])