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.
@PARENT (dimName [, mbrName])
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. |
Sales(@PARENT(Product) = 5;);
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")));
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.
@ANCEST
@CHILDREN
@ANCESTORS
@DESCENDANTS
@SIBLINGS
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |