1. Designer's Guide
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Variables
  4. Creating a Variable
  5. Entering Variable Values for a Member or Members Variable

Entering Variable Values for a Member or Members Variable

The member and members variables are Oracle Hyperion Planning, Oracle General Ledger, and Oracle Essbase replacement variables. These variables contain a member or multiple members from a dimension that you select.

To enter values for a member or members variable:

  1. From Type, select Member or Members.
  2. In the Variable Grid, select a dimension. The dimension that displays is the dimension that belongs to the application for which you are creating the variable.
  3. Enter or use the Member Selector to select limits for the variable. You can select members only from the dimension you select in step 2. You can also select functions. See Working with Functions.

    Note:

    When using a function for the Limit, Planning functions are recommended instead of Essbase functions. In some cases, Essbase functions do not return the expected members; for example, when the evaluation of the Essbase function includes dynamic members. For the Limit in Member or Members variable, use "ILvl0Descendants("Mbr Name") " instead of the Essbase function "@Relative("Mbr Name", 0)".

  4. Enter or use the Member Selector to select a default value for the variable. You can select one member or function for a member variable and multiple members and functions for a members variable.
  5. By default, RTP is selected. If you do not want to create a runtime prompt variable, clear RTP.

    Planning users only

    Note:

    If you do not select RTP, you must enter a value for the variable.

  6. If you selected RTP, enter the runtime prompt text you want to display for users.

    Planning and Essbase users only)

  7. Planning users of Workforce Planning, Capital Asset Planning, Public Sector Budgeting, and Project Financial Planning plan types: If you are using the member type variable in a business rule that has Create dynamic member and/or Delete dynamic member settings enabled, enter a default dynamic parent member in the Dynamic Member Parent column. When you use both of these options,Planning creates members dynamically for this parent before the rule is launched and/or deletes members for this parent after the rule is launched.

    Note:

    You should enable the dynamic member parent for dynamic children in the Planning database outline. After you enable this setting, you should refresh the database.

  8. Select File, and then Save.