@PARENTVAL

Returns the parent values of the member being calculated in the specified dimension.

Syntax

@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.

Example

Example 1

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

Example 2

Adding the "Market Share" member and formula to the outline would produce the same result as above.

See Also

@MDPARENTVAL
@SPARENTVAL
@ANCESTVAL

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com