Selecting Members

Member selection commands are extraction commands that select ranges of members based on database outline relationships, such as sibling, generation, and level. Using member selection commands ensures that any changes to the outline are automatically reflected in the report, unless you change the member name on which the member selection command is based. Attribute dimensions can be included in member selection commands.

Table 103 lists the member selection commands:

Table 103. Report Writer Commands: Member Selection

Report Command

Description

ALLINSAMEDIM

Select members from the same dimension as the dimension member.

ALLSIBLINGS

Include siblings of the specified member.

ANCESTORS

Include ancestors of the specified member.

ATTRIBUTE

Select a base dimension member based on its attributes.

CHILDREN

Select members in the level immediately below the specified member.

DESCENDANTS

Include descendants of the specified member to the report, excluding the dimension top.

DIMBOTTOM

Select all level 0 members for the dimension to which a given member belongs.

DIMTOP

Include the top member of the dimension.

IANCESTORS

Include a member and its ancestors.

ICHILDREN

Select the specified member and members in the level immediately below it.

IDESCENDANTS

Include the specified member and its descendants.

IPARENT

Include the specified member and its parent.

OFSAMEGEN

Include members from the same dimension and generation as the specified member.

ONSAMELEVELAS

Include members from the same dimension and on the same level as the specified member.

PARENT

Include the parent of the specified member to the report.

TODATE

Extract data for a specified date or for a time period before or after a specific date.

WITHATTR

Include base dimension members associated with the specified attribute dimension.