@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