Returns the ancestor values of a specified member combination.
@ANCESTVAL (dimName, genLevNum [, mbrName])
| 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). |
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
@MDANCESTVAL
@SANCESTVAL
@PARENTVAL
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |