Essbase @PARENT

Returns the parent of the current member being calculated in the specified
dimension. If you specify the optional mbrName,
that parent is combined with the specified member.

This member set function can be used as a parameter of another function,
where that parameter is a member or list of members.

Syntax

@PARENT (dimName [, mbrName])
Parameter Description
dimName Single dimension name specification.
mbrName Optional. Any valid single member name or member combination, or a function
that returns a single member or member combination, that is combined with
the parent returned.

Notes

  • You cannot use the @PARENT function in a FIX statement.
  • You can use the @PARENT function on both the left and right
    sides of a formula. If you use this function on the left side of a formula
    in a calculation script, associate it with a member. For example:

    Sales(@PARENT(Product) = 5;);
  • In some cases, the @PARENT function is equivalent to the @PARENTVAL
    function, except in terms of calculation performance. For example, the following
    two formulas are equivalent:

    Sales = @PARENT(Profit);
    Sales = @PARENTVAL(Profit);

    In this case, using the latter formula results in better calculation
    performance. In general, use @PARENT as a member rather than as an implied
    value of a cell. For example:

    Sales = @AVG(SKIPMISSING, @ISIBLINGS(@PARENT("100")));
  • The time required for retrieval and calculation may be significantly
    longer if this function is in a formula attached to a member tagged as Dynamic Calc or Dynamic Calc and Store.
  • If you are using the @PARENT function within @XREF: the @XREF
    function requires the @NAME function to be used around @PARENT. For example:

    COGS=@XREF(Sample, @NAME(@PARENT(Product)),Sales);

Example

In the Sample Basic database:

@PARENT(Market,Sales)

returns Central->Sales, if
the current member of Market being calculated is Colorado.

@PARENT(Measures)

returns Profit, if the current
member of Measures being calculated is Margin.

See Also

  • @ANCEST
  • @CHILDREN
  • @ANCESTORS
  • @DESCENDANTS
  • @SIBLINGS