Functions Available Only Through Member Selection

The member functions listed in the following table can be selected from the Functions tab through member selection. They cannot be entered dynamically in the formula bar.

Table 2. Functions Available Only Through Member Selection

Function	Description
Property
Match	Note: When using the asterisk (*) wildcard with Planning, the pattern may only contain one asterisk and it may only appear as the last character.
MatchEx	Used with Essbase Cloud only. Performs wildcard member selection. Essbase Cloud searches for member names that match the pattern you specify, and returns the member names it finds. Note: See “MATCHEX” in the Technical Reference for Oracle Essbase Cloud for detailed information on this function. Financial Reporting only allows matching on the ALT\|MBR\|BOTH option.
RelativeMember	Note: Arithmetic offset is the distance to move forward or backward on a specified level. Note: When using a time dimension, keep the offset in the same calendar year as the specified level. For example, if you start with June, you can offset back to January or forward to December.
DynamicMemberList
OrderBy	For Planning database connection only, you can specify the order of members that come back from member selection by a member property. The OrderBy function comprises two required parameters: Property—Provides the Member Name option and a list of all properties available for members. Name is the default. Direction—Provides the options for directions: Ascending, Descending, Hierarchy Ascending, Hierarchy Descending. The OrderBy function applies to all member selections in the Selected list.