Returns the ancestor values of a specified member combination.
Syntax
@ANCESTVAL (dimName, genLevNum [, mbrName])
Parameter | Description |
---|---|
dimName | A single dimension name that defines the focus dimension of ancestor values. |
genLevNum | Integer value that defines the generation or level number from which the ancestor values are to be returned. A positive integer defines a generation reference. A negative number or value of 0 defines a level reference. |
mbrName | Optional. Any valid single member name or member combination (or a function that returns a single member or member combination). |
Example
In this example, SKU Share is derived by taking Sales in each SKU as a percentage of its product family. Families are at generation 2; therefore, each descendant of family is calculated as a percentage its respective ancestor. Consolidated results must be calculated for Sales by Product before the SKU Share calculation occurs.
"SKU Share" = Sales % @ANCESTVAL(Product,2,Sales);
This example produces the following report:
Sales SKU Share ===== ========= SKU101 510 26.0 SKU102 520 26.5 Group01 1030 52.5 SKU120 430 21.9 SKU123 500 25.5 Group02 930 47.4 Family1 1960 100.00
See Also