Returns all ancestors of the specified member, including ancestors of any occurrences of the specified member as a shared member. This function excludes the specified member.
Syntax
@ALLANCESTORS (mbrName)
Parameter | Description |
---|---|
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
Notes
Essbase sorts the generated list of members in ascending order of the member number in the outline. Using Sample Basic as an example, if you specify 100-20 for mbrName, 100, Diet, and Product are returned (in that order). However, the order in which shared ancestors are returned is not guaranteed. This order is important to consider when you use the @ALLANCESTORS member set function with certain forecasting and statistical functions.
You can use @ALLANCESTORS as a parameter of another function, where that parameter is a list of members.
Example
The following example is based on the Sample Basic database. Sample Basic has a shared level of diet drinks, which includes 100-20 (Diet Cola). So 100-20 (Diet Cola) is a descendant of 100 (Colas) and is a shared member descendant of Diet:
100 100-10 100-20 … Diet 100-20 (Shared Member) …
The following calculation script increases by 5% the Budget->Sales values of all ancestors of 100-20, including Diet.
FIX(Budget,@ALLANCESTORS("100-20")) Sales = Sales * 1.05; ENDFIX
This example produces the following report. This report shows that the Budget->Sales values for 100, Diet, and Product (the ancestors of 100-20) have been increased by 5%. The original values were 8980, 8260, and 28480, respectively.
Jan Actual Budget Sales Sales ===== ===== Market 100-10 4860 5200 100-20 2372 2610 100-30 1082 1170 100 8314 9429 * 100-20 2372 2610 200-20 3122 3090 300-30 2960 2560 Diet 8454 8673 * Product 31538 30954 *
See Also