Returns all ancestors of the specified member (mbrName) or those up to a specified generation or level. You can use this member set function as a parameter of another function, where that parameter is a list of members.


@ANCESTORS (mbrName [, genLevNum | genLevName])


Any valid single member name or member combination (or a function that returns a single member or member combination).


Optional. An integer value that defines the absolute generation or level number up to which to select the members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.


Optional. Level name or generation name up to which to select the members.



In the Sample Basic database:

@ANCESTORS("New York")

returns East, Market (in that order).


returns Year.


returns 100, Product (in that order).


returns Margin, Profit (in that order).

See Also