1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Working with Custom Templates
  3. Creating Design-Time Prompts for Custom Templates
  4. Types of Design-Time Prompts
  5. StringAsNumber DTP

StringAsNumber DTP

Defines a string as a number.

To create a StringAsNumber design-time prompt:

  1. In the Template Designer, open an existing template or create a new template.
  2. On the Design Time Prompt tab, click Add button.
  3. If you already have design-time prompts defined for the template, select where to enter the new design-time prompt.
  4. In the Create Prompt dialog box, on the Properties tab, do the following:
    • Enter a Name and select StringAsNumber as the Type.
    • Select the desired options:

      • Prompt It?—Select this option to allow the DTP to be used in a step. The DTP is shown in the template steps that prompt users for input when the template is used in a rule, or when a script template is launched in Planning.

      • Mandatory?—Select this option to make it mandatory to enter data for the design-time prompt.

      • Read Only—Select this option to make it so that users can only read the prompt.

      • Is Hidden—Select this option to hide the design-time prompt from the user. In Planning, on the Business Rules tab in form design, add the rule with the template or script template to the form. In the Business Rules Properties pane, select Hide Prompt, and then select Use Members on Form.

    • In DTP Text, enter the text that you want users to see when they are prompted for input.

      If you select Prompt It?, then DTP Text is required.

    • Optional. In Comments, enter a comment about the DTP.

    • Select Allow #Missing to allow #Missing values in the DTP instead of a string.

    • Optional. Select Use System Defaults, and then in Default Value, click the drop-down to select a default value to use in the prompt. The default value is initially populated with the user name.

Note:

If you select Use System Defaults, and from the default, select "user name", then you must select Prompt It, and enter text in DTP Text. Add this design-time prompt to a step. In a rule, when you are prompted for the input for this design-time prompt, select a StringAsNumber variable, that has Use System Defaults, and a user name as the default value.