Creating Cell Text Range Components (Financial Management Users Only)

You create a cell text range component from within the Rule Designer or Template Designer as you are designing a Oracle Hyperion Financial Management business rule or template. Unlike a script or formula component, a cell text range component exists only as a component of the business rule or template to which it belongs. A cell text range component cannot be shared.

To create a cell text range component:

1. In System View, right-click a rule or a template, and then select Open.
2. After you determine where in the flow chart to create the cell text range, from New Objects, drag the Cell Text Range object, and drop it into the flow chart.

   The Cell Text Range object is displayed as two circles with a connecting line in the flow chart.

3. Custom template users only: If you are creating a cell text 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 Cell Text Range tab, do one of these tasks:

   • If you are creating the cell text range for a business rule and want to use a variable to define the cell text range (See Working with Variables) perform these tasks:

     1. Click Variable Selector, and enter or create a variable to define the cell text range.

        Note:

        If you select this option, you cannot define a cell text range for the dimensions in the grid.

     2. Select whether or not to link the variable dynamically to the cell text range component. If you link it dynamically, the variable is updated in the cell text range component whenever changes are made to it elsewhere in Oracle Hyperion Calculation Manager.

     3. For Value Variable, select a replacement string variable that contains a POV. (If you use this button to select variables, it is the same as entering members in the Value column of the grid.)

     4. Optional: From Sort Dimension, select the dimension you want to use for sorting.

     5. Optional If you selected a dimension to use for sorting in the previous step, from Sort Method, select the method by which you want to sort the dimension:

        • Ascending, to sort the dimension members from A to Z. (This is the default setting.)

        • Descending, to sort the dimension members from Z to A.

   • If you are creating the cell text range for a custom template and want to use a design-time prompt to define the cell text range:

     1. Click Variable Selector, and enter or create a variable.

     2. Select whether or not to link the variable dynamically to the cell text range component. If you link it dynamically, the variable is updated in the cell text range component whenever changes are made to it elsewhere in Calculation Manager.

     3. For Value Variable, select a replacement variable of the type Cell Text Range. (Cell text range variables contain complete cell text range definitions.)

     4. Optional: From Sort Dimension, select the dimension you want to use for sorting.

     5. Optional If you selected a dimension to use for sorting in the previous step, from Sort Method, select the method by which you want to sort the dimension:

        • Ascending, to sort the dimension members from A to Z. (This is the default setting.)

        • Descending, to sort the dimension members from Z to A.

   • If you are creating the cell text range for either a business rule or a custom template and want to use variables, members, and functions to define the cell text range:

     1. For the first dimension for which you want to define a cell text range, enter members in the Value column, or click in the row to display the Actions icon.

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

        • Variable (See Working with Variables.)

        • Member (See Adding Members and Functions to a Component.)

        • 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 the Actions icon, and select Variable to select a launch variable. See Working with Variables.

        Note:

        You cannot include a launch variable for the Scenario, Year, Period, Entity, or Value dimensions.

     4. Click the Comments icon to enter comments for the cell text range.

     5. Repeat these steps for each dimension in the grid for which you want to define a cell text range.

     6. For <cell text label>, enter a variable value in the Value column, or click the Actions icon to select a variable to use as the cell text label value. Then for the Variable column, enter a variable, or click the Actions icon to select a variable to define the range.

     7. For <POV>, <index>, and <cell text>, enter a variable in the Variable column, or click the Actions icon to select a variable.

5. Select Enable Timer to incude the time it takes to process the cell text range in the log file when the business rule or template is calculated. The process time is included in the log file for every object whose timer is enabled.
6. Click Reset Grid to display the grid with its default settings.
7. Optional: On the Properties tab, do any of these tasks:

   • Select Disabled to exclude the cell text range component from the business rule or template validation and calculation.

   • Enter a caption to identify the cell text range 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 cell text range component.

8. Click .