@PARENT

The @PARENT calculation function for Essbase 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])

Parameters

dimName: Single dimension name specification.
mbrName: Optional. Any valid single member name, or a function that returns a single member.

Notes

You cannot use this function in a FIX statement.
You can use this 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, @PARENT is equivalent to @PARENTVAL, 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 @PARENT within @XREF, @XREF requires @NAME 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.