Creating a Member Range Component

You create a member range component from within the Rule or Template designer as you are designing a rule or template. Unlike script and formula components that exist independently of the business rules and templates they are used in, you cannot create a member range component from the System View. Member range components are linked to the business rules and templates to which they belong; they cannot be shared.

To create a member range component:

1. In System View, right-click a rule or a template, and then select Open.
2. From New Objects, drag a member range object, and drop it into the flow chart.

   The member range object is displayed as two circles with a connecting line.

3. Custom template users only: If you are creating a member range 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 Member Range tab, do one of the following:

   • Select Variable Selector to use a variable to define the member range. Then enter or select a variable. See Working with Variables.

     Note:

     If you select this option, and you change a member, you receive a message: "Editing the grid will remove the dynamic variable linking. Are you sure you want to continue?" If you want to remove the link to the variable, click Yes. Clicking Yes removes the link to the variable and leaves the member range with the members that were in the variable. If you do not want to lose the link to the variable, click No.

     if you select this option, select Link Variable Dynamically so whenever changes are made to the variable. the variable in the rule or template is updated with these changes.

   • Oracle Hyperion Planning and Oracle Essbase users only:

     1. Enter members in the Value column for each dimension for which you want to define a member ranger, or click in each row to display the Actions icon.

        Tip:

        Rather than selecting members for each dimension, one row at a time, you can click the Member Selector icon to select members for all dimensions in the grid. When you click OK in the Member Selector, the members you selected are displayed for each dimension in the grid for which you selected members.

     2. Click the Actions icon, and select one of these options to define the member range:

        • Variable (See Working with Variables.)

        • Member (See Working with Members.)

        • Function (See Working with Functions.)

     3. Click the Comments icon to enter comments for the member range.

     4. Repeat these steps for each dimension for which you want to define a member range.

     5. Select Exclude Grid Values to exclude the members you select from calculation.

     6. Click Reset Grid to clear any members, variables, and functions you entered in the grid.

     7. Select Enable Parallel Processing to process the member range commands simultaneously, instead of sequentially. (By default, serial processing is used, but parallel processing may optimize the calculations.) Then in the text box, enter the number of threads to be available for parallel processing, or click the Variable Selector to select a numeric or integer type variable if you are creating the member range in a business rule, or a numeric design-time prompt, if you are creating the member range for a template.

        By default, the number of threads for parallel processing is two. For 32-bit platforms, select an integer between 1-4. For 64-bit platforms, select an integer between 1-8.

   • Oracle Hyperion Financial Management users only:

     1. Click in the first row under the Dimension column, and select a dimension.

     2. Enter members in the Value column, or click in the row to display the Actions icon. Click the Actions icon, and select one of these options to define the member range:

        • Variable (See Working with Variables.)

        • Member (See Working with Members.)

        • Function (See Working with Functions.)

     3. Enter a launch variable in the Variable column, or click in the row to display the Actions icon. Click Actions, and select a launch variable. See Working with Variables.

     4. Click the Comments icon to enter comments for the member range.

     5. Repeat these steps for each dimension for which you want to define a member range.

5. Business rules users only: On the Errors and Warnings tab, click the button to run script diagnostics.
6. Optional: On Properties, select Disabled to exclude the member range (and any components within it) from validation. You may want to use this for troubleshooting when a component in a business rule or template is preventing the business rule or template from validating.

   You can also enter a description, comments, and a caption for the member range. The caption is displayed below the component in the flow chart of the rule or template to which it belongs.

7. Financial Management users only: On Properties, select Enable Timer to record the time it takes to process the member range component 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 member range components whose timers are enabled, the time taken to process the rule, and each member range component in the rule, is recorded.
8. Click .