Creating a Fixed Loop Component

You create a fixed loop component in a business rule or template by dragging its icon and dropping it into the Rule Designer or Template Designer flow chart. A fixed loop component exists only within the business rule or template for which you create it. Fixed loop components cannot be shared across business rules or templates.

Note:

You can use Fixed loop components in Oracle Hyperion Financial Management, Oracle Hyperion Planning, and Oracle Essbase block storage business rules and custom templates.

To create a fixed loop component:

1. In System View, right-click a rule or a template, and then select Open.
2. After you determine where in the business rule or template flow chart you want to create the fixed loop, from New Objects, drag the Fixed Loop object, and drop it into the flow chart.

   The fixed loop is displayed as two circles connected by a line.

3. Custom template users only: If you are creating a fixed loop component for a template, create design-time prompts for it on the design-time prompt tab. See Creating Design-Time Prompts for Custom Templates.
4. On the Fixed Loop tab, do these tasks:
   1. In Value, enter the number of times you want the loop to cycle through the metadata or data. Or click the Actions icon and select Variable (if you are working with a business rule) or DTP (if you are working with a custom template) or Function (if you are working with either a business rule or a custom template) to select variables, design-time prompts, or functions to define the loop. See Working with Variables and Working with Functions.
   2. In Break Variable, enter a variable, or click the Variable icon (if you are working with a business rule) or the DTP icon (if you are working with a custom template) to choose a numeric variable or a design-time prompt, respectively, to exit the fixed loop. The value of the break variable must be one.
   3. On the Errors and Warnings tab, click the button to run script diagnostics.
5. Financial Management business rules and custom templates users only: On the Fixed Loop tab, do these tasks:
   1. In Value, enter the number of times you want the loop to cycle through the metadata or data. Or click the Actions icon and select Variable (if you are working with a business rule) or DTP (if you are working with a custom template) or Function (if you are working with either a business rule or a custom template) to select variables, design-time prompts, or functions to define the loop. See Working with Variables and Working with Functions.
   2. In Variable, enter a variable, or click the Variable icon (if you are working with a business rule) or the DTP icon (if you are working with a custom template) to choose a numeric variable or a design-time prompt, respectively.
6. Optional: On the Properties tab, do any of these tasks:

   • Select Disabled to exclude the fixed loop component from the business rule or template validation and calculation.

   • Enter a caption to identify the fixed loop component. The caption is displayed below the component in the flow chart of the rule or template to which it belongs.

   • Enter a description and comments for the fixed loop component.

7. Financial Management Users Only: Select Enable Timer to include the time it takes to process the fixed loop in the log file when the business rule is launched. You can enable the timer for rules, rulesets, and components. The process time is included in the log file for every object whose timer is enabled. For example, if you have a rule whose timer is enabled and the rule contains three fixed loops whose timers are enabled, the time taken to process the rule, and each fixed loop in the ruleset, is recorded.
8. Click .