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