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 Values for a Member Range Variable

Entering Values for a Member Range Variable

A member range variable can be a Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle General Ledger, or Oracle Essbase replacement variable. The member range variable should contain a range of members.

To enter values for a member range variable:

  1. From Type, select Member Range.

  2. In the Variable Grid, do one of these, depending on whether you are creating a member range for Financial Management, Planning, Oracle General Ledger, or Essbase.

    1. If you are creating a member range variable for Financial Management:

      1. Select a dimension to limit the member selection. If you select a dimension, the Member Selector displays members only for that dimension. If you do not select a dimension, the Member Selector displays all dimensions.

      2. In Value, enter a value for the variable, or select the Actions icon to enter members, variables, or functions for the variable value.

      3. In Variable, select the Variable icon to select a variable for the member range.

      4. Click the Comments icon to enter comments for the variable.

      5. Repeat these steps for each dimension for which you want to define a member range.

    2. If you are creating a member range variable for Planning, Oracle General Ledger, or Essbase:

      1. For each dimension in the table for which you want to select limits for the member range, click in the limit field and enter a limit. (The dimensions that display are the dimensions that belong to the application for which you are creating the variable.)

        At the global level, if you select the Dimension Type option, only the standard dimension types are shown. If you select the Dimension Names option, you can type in any dimension name.

        Note:

        (Planning and Essbase users only) You must select RTP before you enter text in the Limits field.

        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 a member range variable, use "ILvl0Descendants("Mbr Name") " instead of the Essbase function "@Relative("Mbr Name", 0)".

      2. Enter or use the Member Selector to select default values for the member range, or if the variable is a runtime prompt, you can leave the default value empty. You can select multiple members and functions for each dimension listed.

      3. (Planning and Essbase users only) Select RTP for each dimension listed if you want the variable to prompt users for information when it is launched.

        Note:

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

      4. (Planning and Essbase users only) For each dimension for which you selected RTP, enter the runtime prompt text..

      5. in the RTP text box above the grid enter the RTP text you want to display for users each time the variable is launched for that dimension.

  3. Click Save button.