Entering Runtime Prompts

When launched, a business rule can prompt you to enter variable information, called a runtime prompt. The business rule designer sets up runtime prompts. To learn how the display and values of runtime prompts are affected by certain settings and conditions, see “Understanding Runtime Prompts” in Oracle Hyperion Planning Administrator's Guide.

Notes:

  • If a business rule has a runtime prompt and Use Members on Forms is selected, the default member on the runtime prompt window matches the current member in the page or POV axes of the open form.

  • Members and substitution variables on the Member Selection page are filtered by your access permissions and limitations set for the runtime prompt (for example, only Descendants of Q1). You cannot select a shared member in a runtime prompt.

  • If multiple business rules having runtime prompts are launched when saving the form, enter values for each one successively, using the Next button.

  To enter a runtime prompt:

  1. Launch a business rule having a runtime prompt.

    See About Launching Business Rules.

  2. Specify the input type specified by the runtime prompt as outlined in this table:

    Icon

    Expected Input Type

    Single Member Selection icon

    One member selection

    Multiple Member Selection icon

    Multiple member selections

    Numeric Value icon

    Numeric value

    Numeric Value icon

    Smart List value—Select an item from the list

    Text Value icon

    Text value—Use only with enhanced calculation scripts, not with graphical scripts.

    Dimension icon

    Dimension from the database—Use only with enhanced calculation scripts, not with graphical scripts.

    Cross Dimension runtime prompt icon

    Cross Dimension—A member combination that includes only one member from each dimension the designer has set for this runtime prompt (for example: Sales -> Actual -> Jan refers to the member intersection of Sales, Actual, and January).

    Member Range runtime prompt type icon

    Member range—A range of members, selectable from each dimension the designer has set for this runtime prompt (for example: IDescendants(“Marketing”),FY11).
  3. If any runtime prompt values are not valid, correct them.

    Symbols indicate whether the values in runtime prompts are valid:

    Valid Member icon—The runtime prompt values are valid.

    Invalid Member icon—The runtime prompt values are not valid (for example, the entry does not exist in the dimension hierarchy). You cannot launch a business rule until all runtime prompt values are valid.

    Note: If an administrator enabled the member parent for dynamic children (as described in “About Dynamic Members” in the Oracle Hyperion Planning Administrator's Guide), you can create a member by entering its name now in the runtime prompt.

  4. Optional: To generate a file containing the runtime prompt values, select Create runtime prompt values file.

    The file is saved as rule_name.XML, in the EPM_ORACLE_INSTANCE/planning/Planning1/RTP/user_name folder. Administrators specify this generated file when launching business rules with the CalcMgrCmdLineLauncher.cmd utility (see the Oracle Hyperion Planning Administrator's Guide).

  5. Click Launch.

    If the calculation is successful, the values in the database reflect the calculation results. See also Checking Job Status.

If you are using an Oracle Essbase substitution variable as the runtime prompt value and the value of that substitution variable is outside of the variable limits, the limits are ignored, and the rule launches successfully.