Functions Available Through Member Selection and the Formula Bar
The functions listed in Table 6-1 can be selected from the Functions tab in the Select Member dialog box, and they can be entered dynamically in the formula bar.
Table 6-1 Functions Available Through Member Selection and the Formula Bar
Function | Parameters Needed | Description |
---|---|---|
AllMembers | All Members in Hierarchy dimension | Members of the specified dimension |
Ancestors | Ancestors of member (Inclusive) | Members at all levels above the specified member |
Base | Base members of Hierarchy dimension | The base or level 0 members of a hierarchy. Base Member function is only available for Oracle Hyperion Financial Management, and is not supported for Oracle Essbase and Oracle Hyperion Planning. For Essbase and Planning, use BottomOfHierarchy AND Descendants functions.
|
BottomOfHierarchy | Bottom of Hierarchy dimension | All Level 0 members |
TopOfHierarchy | Top of Hierarchy dimension | Top-level member of hierarchy |
Children | Children of member (Inclusive) | Members one level below the specified parent |
Descendants | Descendants of member (Inclusive) | Members at all levels below the specified parent |
Parent | Parent of member (Inclusive) | Member one level above the specified member |
Siblings | Siblings of member (Inclusive) | Members with the same parent as the specified member |
Member | member | The specified member |
Members | N/A | Members of the current dimension |
OfSameGeneration | Same generation as member | Members of the same dimension and generation as the specified member |
OnSameLevelAs | Same level as member | Members from the same dimension and on the same level as the specified member
Note: In Planning, OnSameLevelAs only works with level 0 members. |
SameLevelAs | N/A | Members of the same level |
SystemMemberList | System-defined Member List Lev(n),dimension | Members in a specified system-defined member list |
UserDefined1 | All members where user defined is selected attribute | Financial Management only. All entities and custom dimensions can be used with the following exceptions: View, ICP, Year, Period, Scenario. The members of selected attribute |
UserDefined2 | All members where user defined is selected attribute | Financial Management only. All entities and custom dimensions can be used with the following exceptions: View, ICP, Year, Period, Scenario. The members of selected attribute |
UserDefined3 | All members where user defined is selected attribute | Financial Management only. All entities and custom dimensions can be used with the following exceptions: View, ICP, Year, Period, Scenario. The members of selected attribute |