Which filter shows all results of all Members in the AMS_500 Member of the Entity Dimension, including the AMS_500 member?

Which filter shows all results of all Members in the AMS_500 Member of the Entity Dimension, including the AMS_500 member?

• A. E#AMS_500.TreeDescendants
• B. E#AMS_500.TreeDescendantsInclusive
• C. E#AMS_500.Descendants
• D. E#AMS_500.ParentDescendantsInclusive

Answer: (B)

In a hierarchical dimension, including the base member itself is done with the inclusive variant of the tree-descendant filter. TreeDescendantsInclusive returns AMS_500 plus all of its descendants, so you get every member under AMS_500 together with AMS_500 itself. That matches the requirement of “including the AMS_500 member.” The non-inclusive TreeDescendants would give only the descendants under AMS_500, excluding AMS_500 itself. Descendants generally refers to the same idea (descendants only, not the member). ParentDescendantsInclusive would pull in the parent’s set of descendants as well, which goes beyond the requested scope.

In a hierarchical dimension, including the base member itself is done with the inclusive variant of the tree-descendant filter. TreeDescendantsInclusive returns AMS_500 plus all of its descendants, so you get every member under AMS_500 together with AMS_500 itself. That matches the requirement of “including the AMS_500 member.”

The non-inclusive TreeDescendants would give only the descendants under AMS_500, excluding AMS_500 itself. Descendants generally refers to the same idea (descendants only, not the member). ParentDescendantsInclusive would pull in the parent’s set of descendants as well, which goes beyond the requested scope.