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 Numeric Variable

Entering Variable Values for a Numeric Variable

A numeric variable can be a Oracle Hyperion Planning, Oracle Essbase, Oracle General Ledger, or Oracle Hyperion Financial Management replacement variable. A numeric variable can also be a Financial Management execution variable.

To enter values for a numeric variable:

  1. From Type, select Numeric.

  2. To use a Smart List, create the variable at the application, plan type, or rule level. (You cannot use the Smart List at the global level.) Then click in the Smart List box, click on the dropdown list, and select a Smart List.

    Planning users only

    See Administering Planning for Oracle Planning and Budgeting Cloud Service for this release. For example, you can set up an integer Smart List for a reporting cycle that has values 1-5, for Yearly (1), Quarterly (2), Monthly (3), Daily (4), and Hourly (5). A user can select "Monthly" and the number three is stored in the database. This prevents users from having to remember the numbers.

    You can also set up a string of text or a date as the value for the Smart List.

    Note:

    You must select a Planning application that supports the use of Smart Lists.

  3. To use a numeric runtime prompt, leave the Smart List box empty, then go to the next step.

  4. (Planning users only) In Limits, select a limit for the Smart List.

    Note:

    If you are using an Essbase substitution variable as the runtime prompt value and the value of that substitution variable is outside of variable limits, launching a rule does not give any error and launches successfully.

  5. Optional: Enter a default value for the variable.

  6. By default, RTP is selected. If you do not want to create a runtime prompt for this variable, clear RTP.

    Planning users only)

    Note:

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

  7. If you selected RTP, enter the runtime prompt text you want to display as the default value for users.

    Planning and Essbase users only

  8. Specify whether missing data values are allowed.

    Planning users only

  9. Click Save button.

To enter values for a Financial Management replacement or execution numeric variable:

  1. Enter a value, or click in the Value field to display the Actions icon.

  2. Do one of these tasks:

  3. Click Save button.