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 Date as Number Variables

Entering Variable Values for Date as Number Variables

The Date as Number variable can be a Planning replacement or execution variable.

To enter values for a date as number variable:

  1. From Type, select Date as Number.
  2. Optional: In the Value table, click in Limits to define minimum and maximum values for the variable. The minimum and maximum values should be entered as numbers in the format of YYYYMMDD.
  3. Optional: Enter a numeric value for the variable. For dateasnumber variables, enter a date in the numeric format of YYYYMMDD.
  4. By default, RTP is selected. If you do not want to create a runtime prompt, clear RTP.

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

  5. If you selected RTP, enter the runtime prompt text you want to display for users.
  6. Select whether to allow #Missing values.
  7. Select Use last entered value, to allow users to use the last value they entered.
  8. Click Save button.