Descendants

Returns the set of descendants of a member at a specified level or a specific distance away in the hierarchy. Optionally you can include or exclude 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»]])

Syntax 3

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

Syntax 4

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

Example

SELECT Descendants([Car Tires All Season]) ON 0,
Descendants([2016]) ON 1 FROM DCS_Planning