@PARENTVAL

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

Syntax

@PARENTVAL (dimName [, mbrName])
Parameter Description

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

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.

Outline snippet showing member [Market Share] added as a sibling to [Sales], and with the member formula

See Also