Adding One Member or Function from One or More Dimensions to a Component

The Member Selector enables you to select members and functions within a dimension. Expand and collapse members within a dimension using the [+] and [-].

The Member Selector dialog box has three tabs—all members and functions in the selected dimension are on the Members tab and the Functions tab. There is a third tab, Search, that you use to search for members or member descriptions. The members and functions you select are listed under Selections on the right.

To add a member from one dimension or more dimensions to a component:

1. In System View, right-click a template or business rule, and then select Open.
2. When the business rule or template opens, in its flow chart, select the component to which you want to add a member.

   Note:

   You cannot add a member to a fixed loop component.

3. Click the Member Selector icon.
4. In the Member Selector, from Dimensions, select a dimension.

   The members for the dimension you select are displayed on Members.

5. Do one of these tasks:

   • On Members, select a member, and click the right arrow button to move it to the Selections list. You can also use the options in this table to further define the selection.

     Table 8-1 Member Selector Buttons

     Button	Description
     Add Special	(Oracle Hyperion Planning and Oracle Essbase block storage applications users only) Select one of these to add additional members or functions related to the member or function you selected on the tab: Member Children iChildren Descendents iDescendents Siblings iSiblings Parent iParent Ancestors iAncestors Relative Level 0 (Base) Inclusive (Essbase aggregate storage application users only) Select one of these to add additional members or functions related to the member or function you selected on the tab: Siblings Level 0 Descendants Note: Planning does not have Level 0 (Base) or Inclusive in its Add Special selections.
     Select	Select to move the member or function to the Selections list.
     Deselect	Select to remove the member or function from the Selections list.
     Deselect All	Select to remove all members and functions from the Selections list.

   • In Functions, do these tasks:

     Planning and Essbase block storage application users only:

     1. Select a function.

     2. Enter the required values for the function, according to this table:

        Table 8-2 Functions and Values

        Function	Values to Enter	Description
        @ALLANCESTORS	Member Name	Enter the member name or click Member to select a member.
        @ANCEST	Dimension Name Generation Level Number Member Name	Enter the dimension name you selected in Dimensions. Enter an integer value that defines the generation or level number from which the ancestor value is returned. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number. Enter any member name or member combination.
        @ANCESTORS	Member Name Generation Level Number Generation Level Name	Enter a member name or member combination. Enter an integer value that defines the absolute generation or level number up to which to include members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number. Enter a level name or generation name up to which to include members in the selection.
        @ATTRIBUTE	Attribute Member Name	For the dimension you entered, enter the attribute member name or member combination you want to include in the selection.
        @CHILDREN	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @CURRMBR	Dimension Name	Enter the dimension name.
        @DESCENDANTS	Member Name Generation Level Number Generation Level Name	Enter a member name or member combination. Enter an integer value that defines the absolute generation or level number up to which to include members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number. Enter a level name or generation name up to which to include members in the selection.
        @GENMBRS	Dimension Name genName	Enter a dimension name. Enter a generation name from dimName. A positive integer defines a generation number.
        @IALLANCESTORS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @IANCESTORS	Member Name Generation Level Number	Enter a member name or member combination, or a function that returns a member or member combination. Enter an integer value that defines the absolute generation or level number up to which to include members in the selection. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
        @ICHILDREN	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @IDESCENDANTS	Member Name Generation Level Number	Enter a member name or member combination, or a function that returns a member or member combination. Enter an integer value that defines the absolute generation or level number up to which to include members in the selection. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
        @ILSIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @IRDESCENDANTS	Member Name Generation Level Number	Enter a member name or member combination, or a function that returns a member or member combination. Enter an integer value that defines the absolute generation or level number up to which to include members in the selection. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
        @IRSIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @ISIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @LEVMBRS	Dimension Name Level Name	Enter a dimension name. Enter a level name or an integer value that defines the number of a level. The integer value must be 0 or a positive integer.
        @LIST	Argument	Enter a list of arguments that will be collected and treated as one argument so they can be processed by the parent function. Arguments can be member names, member combinations, member set functions, range functions, and numeric expressions.
        @LSIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @MATCH	Member, Generation genName Pattern to Match	Enter the default or user-defined name of the member on which to base the selection. The system searches the member names and alias names of the specified member and its descendants. Enter the default or user-defined name of the generation on which to base the selection. The system searches all member names and member alias names in the generation. Enter the character pattern to search for, including a wildcard character ( or ?). ? substitutes one occurrence of any character. You can use ? anywhere in the pattern. substitutes any number of characters. You can use only at the end of the pattern. To include spaces in the character pattern, enclose the pattern in double quotation marks ("").
        @MEMBER	String	Enter a string (enclosed in double quotation marks) or a function that returns a string.
        @MERGE	List 1 List 2	Enter the first list of members to be merged. Enter the second list of members to be merged.
        @PARENT	Dimension Name Member Name	Enter the dimension name. Enter a member name or member combination, or a function that returns a member or member combination, to be combined with the parent returned.
        @RANGE	Member Name Range List	Enter a member name or member combination, or a function that returns a member or member combination, to be combined with the parent returned. Enter a member name, a comma-delimited list of member names, member set functions, or range functions. If rangeList is not specified, the system uses the level 0 members from the dimension tagged as Time.
        @RDESCENDANTS	Member Name Generation Level Number	Enter a member name or member combination, or a function that returns a member or member combination, to be combined with the parent returned. Enter an integer value that defines the absolute generation or level number down to which to select the members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
        @RELATIVE	Member Name Generation Level Number	Enter a member name or member combination, or a function that returns a member or member combination, to be combined with the parent returned. Enter an integer value that defines the absolute generation or level number down to which to select the members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
        @REMOVE	List 1 List 2	Enter the first list of members to be merged. Enter the second list of members to be merged.
        @RSIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @SHARE	Range List	Enter a comma-delimited list of members, functions that return members, or ranges of members. All the members in rangeList must be from the same dimension.
        @SIBLINGS	Member Name	Enter a member name or member combination, or a function that returns a member or member combination.
        @UDA	Dimension Name User Defined Attribute	Enter the name of the dimension with which the user-defined attribute is associated. Enter the name of the user-defined attribute as it appears in the database outline.
        @WITHATTR	Dimension Name Operator Value	Enter the name of the attribute dimension. Enter the operator specification, enclosed in quotation marks (""). Enter a value that, in combination with the operator, defines the condition that must be met. The value can be an attribute member specification, a constant, or a date-format function (that is, @TODATE).
        @XRANGE	Member Name 1 Member Name 2	Enter a member name, member combination, or function that returns a single member. Enter a member name, member combination, or function that returns a single member. If mbrName1 is a cross-dimensional member (such as Actual->Jan), then mbrName2 must be also, and the dimension order must match the order used in mbrName1.

        See Working with Functions for a list of supported functions types for Oracle Hyperion Financial Management, Planning, and Essbase block storage applications.

     3. Click the right arrow button to move the function to the Selections list. You can also use the options in Table 8-1 to further define the selection.

   • On Search, do these tasks to search for a member or members:

     1. From Dimensions, select a dimension in which you want to search for a member.

     2. Under Find, select a type of member to search for, a member name or its description.

     3. Enter the name of the member, or its description, to search for, or to display all members in the dimension, accept the default wildcard (*).

     4. Select Search to search for a member you enter in the field. (See Searching for Members within the Member Selector.)

     5. Select Advanced Search to access advanced search options. (See Searching for Members within the Member Selector.)

     6. Select the member or members, and click the right arrow to move them to the Selections list. You can also use the options in Table 8-1 to further define the selection.

   • Financial Management Users Only: On Lists, do these tasks:

     1. Select a member list for the dimension you selected, and enter the parameters for the list according to this table:

        Table 8-3 Financial Management Member Lists and Parameters

        Dimension	Member Lists and Parameters
        Account	For Hierarchy, Descendants, Ancestors, Parents, Children, and Base, enter values for these parameters: Top Member Active Entities Scenario Year Period For System, enter no parameters.
        Entity	For Hierarchy, Descendants, Ancestors, Parents, Children, and Base, enter values for these parameters: Top Member Active Entities Scenario Year Period For Adjustment Entities, and Parent Adjustment Entities, enter no values.
        ICP	For Hierarchy, Descendants, Ancestors, Parents, Children, and Base, enter values for these parameters: Top Member Active Entities Scenario Year Period For System, enter no values.
        Period	For Hierarchy, Descendants, Ancestors, Parents, and Children, enter values for these parameters: Top Member Active Entities Scenario Year Period For First Generation, Second Generation, Third Generation, Fourth Generation, Fifth Generation, and Sixth Generation, enter no values.
        Scenario	For Hierarchy, Descendants, Ancestors, and Parents, enter values for these parameters: Top Member Active Entities Scenario Year Period For Support Process Management, enter no values.
        Value	For Hierarchy, and Descendants, enter values for these parameters: Top Member Active Entities Scenario Year Period For Input, Adjustments, Totals, and Default Currencies, enter no values.
        View	For Hierarchy, and Descendants, enter values for these parameters: Top Member Active Entities Scenario Year Period
        Year	For Hierarchy, and Descendants, enter values for these parameters: Top Member Active Entities Scenario Year Period

     2. Click the right arrow to move the member list to the Selections list. You can also use the options in Table 8-1 to further define your selection.

6. Do one of these tasks:

   • If you are selecting a member, function, or member list for either of the following, proceed to step 7.

     • A variable value whose type is member

     • A function where the parameter is member

   • Repeat the previous two steps until you select a member, function, or member list for each dimension, if you are selecting a member, function, or member list for any of the following, Then proceed to the next step.

     • The global range of a Planning or Essbase business rule

     • A template where the design-time prompt type is an intersection of members

     • A variable value whose type is members

     • A variable limit whose type is member

     • A loop component

     • A function where the parameter is members

7. Click OK.