1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  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 Planning replacement 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.

    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. Optional: In Limits, select a limit for the variable.

  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.

    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.

  8. Specify whether missing data values are allowed.

  9. Click Save button.

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