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

See Also

  • @MDPARENTVAL
  • @SPARENTVAL
  • @ANCESTVAL