DESCENDANTS

Adds the descendants of the specified member to the report, excluding mbrName itself.

Syntax

<DESCENDANTS mbrName

mbrName Name of parent of descendants to include.

Description

Adding the descendants of the top of the dimension adds all the members in the dimension to the report, except the dimension top. The IDESCENDANTS command includes the specified member.

Notes

Example

<DESCENDANTS Year

Which selects members Jan, Feb, Mar, Q1, Apr, May, June, Q2, Jul, Aug, Sep, Q3, Oct, Nov, Dec, Q4.

See Also

CHILDREN
ICHILDREN
IDESCENDANTS

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com