Returns the parent values of the member being calculated in the specified dimension.
@PARENTVAL (dimName [, mbrName])
dimName | Single dimension name specification that defines the focus dimension of parent values. |
mbrName | Optional. Any valid single member name or member combination, or a function that returns a single member or member combination. |
This example is based on the Sample Basic database. The formula calculates Market Share for each state by taking each state's Sales value as a percentage of Sales for East (its parent) as a whole. Market Share->East is calculated as East's percentage of its parent, Market.
"Market Share" = Sales % @PARENTVAL(Market,Sales);
This example produces the following report:
Cola Actual Jan Sales Market Share ===== ============ New York 678 37.42 Massachusetts 494 27.26 Florida 210 11.59 Connecticut 310 17.11 New Hampshire 120 6.62 East 1812 37.29 Market 4860 100
Adding the "Market Share" member and formula to the outline would produce the same result as above.
@MDPARENTVAL
@SPARENTVAL
@ANCESTVAL
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |