@PARENTVAL

The @PARENTVAL calculation function for Essbase returns the parent values of the member being calculated in the specified dimension.

Syntax

@PARENTVAL (dimName [, mbrName])

Parameters

dimName: Single dimension name specification that defines the focus dimension of parent values.
mbrName: Optional. Any valid single member name, or a function that returns a single member.

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.