Selecting a Variable

You can select a variable from various locations. You can select variables as you create components from within the Component Designer, as you create design-time prompts from within the Template Designer, and other locations in Oracle Hyperion Calculation Manager.

To select a variable:

  1. Do one of these tasks:

    • Right-click the template that contains the component you want to add a variable to, and select Open.

    • Right-click the business rule that contains the component you want to add a variable to, and select Open.

  2. When the business rule or template opens, in its flow chart, select the component for which you want to insert a variable.
  3. In the tabs below the flow chart, do one of these tasks:

    • For member range components, click in the dimension field, select the Actions icon, and select Variable to select a member range variable. Or click on the Variable Selector to select a member range variable.

    • For data range and fixed loop components, in the Variable field, select the Variable icon.

    • For formula components, click the Actions icon, and select Variable.

    • For script components, click the Insert a Variable icon.

    • For condition components, launch the Condition Builder, click the Actions icon, and select Variable.

  4. In Select Variable, do one of these tasks:

    • To create a new variable, click Create to access the Variable Designer. See Creating a Variable.

    • To select an existing variable, from Category, select the level that contains the variable you want to use. You can select:

      • Global: The variable was created at the global level and can be used by all applications under this application type.

        Oracle Hyperion Financial Management and Oracle Hyperion Planning users only

      • Application: The variable was created at the application level, and is only shown for this application.

      • Plan Type or Database: The variable was created at the plan type or database level and is only shown in this plan type or database.

        Planning, Oracle Fusion General Ledger, and Oracle Essbase users only

      • Rule: The variable was created at the rule level and is only shown for the rule in which it was created.

        Planning, General Ledger, and Essbase users only)

    Note:

    Planning and Essbase users only: For member range, member block, formula, fixed loop, and condition components, the variables shown are restricted to the expected type of variable that the component uses, so, all of the available variables for the selected scope are not shown by default. To see all of the available variables in the selected scope, select the Show all variables check box.

  5. On Replacement or Execution, select one or more variables to insert into the component.
  6. Click OK, and the Save button.