Generating Member Lists

Member set functions allow you to generate member lists that are based on a specified member or member list. Table 55 lists member set functions:

Table 55. List of Member Set Functions

Function

Contents of Member List

@ALLANCESTORS

All ancestors of the specified member, including ancestors of the specified member as a shared member. This function does not include the specified member.

@IALLANCESTORS

All ancestors of the specified member, including ancestors of the specified member as a shared member. This function includes the specified member.

@ANCEST

The ancestor of the specified member at the specified generation or level

@ANCESTORS

All ancestors of the specified member (optionally, up to the specified generation or level), but not the specified member

@IANCESTORS

All ancestors of the specified member (optionally, up to the specified generation or level), including the specified member

@LANCESTORS

All ancestors of the specified list of members (optionally, up to the specified generation or level), but not including the specified members

@ILANCESTORS

All ancestors of the specified list of members (optionally, up to the specified generation or level), including the specified members

@ATTRIBUTE

All base-dimension members that are associated with the specified attribute-dimension member

@WITHATTR

All base members that are associated with attributes that satisfy the specified conditions

@BETWEEN

All members whose name string value fall between, and are inclusive of, two specified string tokens

@CHILDREN

All children of the specified member, but not including the specified member

@ICHILDREN

All children of the specified member, including the specified member

@CURRMBR

The current member being calculated for the specified dimension

@DESCENDANTS

All descendants of the specified member (optionally, up to the specified generation or level), but not the specified member nor descendants of shared members

@IDESCENDANTS

All descendants of the specified member (optionally, up to the specified generation or level), including the specified member, but not descendants of shared members

@LDESCENDANTS

All descendants of the specified list of members (optionally, down to the specified generation or level), but not including the specified members

@ILDESCENDANTS

All descendants of the specified list of members (optionally, down to the specified generation or level), including the specified members

@RDESCENDANTS

All descendants of the specified member (optionally, up to the specified generation or level), including descendants of shared members, but not the specified member

@IRDESCENDANTS

All descendants of the specified member (optionally, up to the specified generation or level), including the specified member and descendants of shared members

@EQUAL

Member names that match the specified token name

@NOTEQUAL

Member names that do not match the specified token name

@EXPAND

Expands a member search by calling a member set function for each member in a member list

@GENMBRS

All members of the specified generation in the specified dimension

@LEVMBRS

All members of the specified level in the specified dimension

@LIKE

Member names that match the specified pattern.

@LIST

Separate lists of members to be processed by functions that require multiple list arguments

@MATCH

All members that match the specified wildcard selection

@MBRCOMPARE

Member names that match the comparison criteria

@MBRPARENT

Parent of the specified member

@MEMBER

The member with the name that is provided as a character string

@MERGE

A merged list of two member lists to be processed by another function

@PARENT

The parent of the current member being calculated in the specified dimension

@RANGE

A member list that crosses the specified member from one dimension with the specified member range from another dimension

@REMOVE

A list of members from which some members have been removed

@RELATIVE

All members of the specified generation or level that are above or below the specified member

@SHARE

A member list that identifies all shared members among the specified members

@SIBLINGS

All siblings of the specified member, but not the specified member

@ISIBLINGS

All siblings of the specified member, including the specified member

@LSIBLINGS

All siblings that precede the specified member in the database outline, but not the specified member

@RSIBLINGS

All siblings that follow the specified member in the database outline, but not the specified member

@ILSIBLINGS

All siblings that precede the specified member in the database outline, including the specified member

@IRSIBLINGS

All siblings that follow the specified member in the database outline, including the specified member

@SHIFTSIBLING

The sibling at the specified distance from the member

@NEXTSIBLING

The next, or right-most, sibling of the member

@PREVSIBLING

The previous, or left-most, sibling of the member

@UDA

All members that have a common UDA defined on Essbase Server

@XRANGE

A member list that identifies the range of members between (and inclusive of) two specified single or cross-dimensional members at the same level