Designing a Formula Component (Financial Management, Planning, and Essbase Block Storage Application Users Only)

You can create a formula component from the System View. You can also create a formula component from within the Rule or Template Designer as you are designing a business rule or template. Formula components can be used in business rules and templates.

  To create a formula component:

  1. In the System View, expand the Financial Management, Planning, or Essbase application type, the application, the calculation type (for Financial Management), the plan type (for Planning), or the database (for Essbase), and Formulas.

  2. Do one of these tasks:

    • Select File, New, Formula Component.

    • Right-click Formulas, and select New.

      Note:

      You can also create a formula component from within a business rule or template by dragging a new formula component into the business rule or template flow chart.

  3. Enter a name, application type, and application to which the formula component belongs. Then do one of the following:

    • Financial Management users only: If you are creating aFinancial Management formula component, enter the calculation type.

    • Planning users only: If you are creating a Planning formula component, enter the plan type.

    • Essbase users only: If you are creating an Essbase formula component, enter the database.

  4. Click OK.

  5. On Properties, complete these steps:

    1. Users creating a formula component for a business rule only: When you create a formula component, Shared is not selectable. When you drag the formula component and drop it into the flow chart of a rule or template, Shared is selected by default. To create a copy of the formula component within the rule or template instead, clear Shared.

    2. Optional: Edit the formula's name by entering a new one of up to 50 characters. (The name defaults from the New Formula dialog.)

    3. Optional: Enter a description of up to 255 characters for the formula.

    4. Enter a caption for the formula. The caption is displayed below the formula in the Rule Designer and Template Designer flow charts.

      Note:

      If you do not enter a caption, the component's name is displayed in the flow chart.

    5. Enter comments for the formula. For example, you may want to tell users what the formula should be used for.

  6. Financial Management users only: Select Enable Logging so, if the formula has log text, it is included in the log file when the rule is launched. You can enable logging for rules, rulesets, and components. However, you specify what log text to include, if any, in the business rule's formula statements.

    Note:

    If logging is not enabled for a ruleset, but is enabled for a rule and component that belong to the ruleset, no log file is created because the log setting for the ruleset overrides the settings for the rule and component.

  7. Financial Management users: Select Enable Timer so the time taken to process the formula is recorded in the log file when the 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 formulas whose timers are enabled, the time taken to process the rule, and each formula in the rule, is recorded.

  8. Financial Management users creating a formula component for a business rule only: Select Disabled to temporarily disable the formula component within any business rules using it while the script is generated.

  9. Optional: On Formula, you can perform any of these tasks:

    • Click Add Grid, and select Insert Grid Before, Insert Grid After, or Insert Grid At End to add another grid. By default, the Formula tab displays one grid.

    • Click Delete Grid to delete a selected grid.

    • Click the Find icon to find text in the formula grid in which you are working. Perform these tasks:

      1. In Find what, enter the text to search for in the formula grid.

      2. Select Match case if you want the text to match the case of the text in Find what.

      3. Select Match whole word if you want the text to match the whole word you enter in Find what.

      4. Select Wrap search if you want the search to start from the row you select in the grid and finish at the same row. For example, assume you select Wrap search in a grid with five rows, and you start the search at row three. If nothing is found in rows four and five, the search continues through rows one and two and stops at row three where it began. If you do no select Wrap search in the same scenario, only rows three, four, and five are searched.

      5. Click Find.

    • Click the Find and Replace icon to find and replace text within the script.

      1. In Find what, enter the text you want to find in the script.

      2. In Replace with, enter the text with which you want to replace it.

      3. Select Match case if you want the text you are searching for to match the case of the text you enter in the dialog.

      4. Select Match whole word if you want the text you are searching for to match the whole word (versus a part of the word) you enter in the dialog.

      5. Select Wrap search if you want the search to start from the row you select in the grid and finish at the same row.

      6. Click Replace to find and replace one instance of the text string at a time.

      7. Click Replace All to find and replace all instances of the text string simultaneously.

  10. On Formula, enter a caption for the formula.

  11. Users creating a formula component for a template only: Select Use Design Prompt if you want to use a design time prompt in the formula component. Then in the condition grid, define a condition for the design time prompt by performing these tasks:

    1. In DTP, select a design time prompt.

    2. In Operator, select an operator: = = or <>.

    3. In Value, enter or select a value for the design time prompt.

    4. Repeat these steps to create as many statements in the condition as you need.

      Tip:

      Click the plus (+) and minus (-) icons to add and delete rows from the

  12. Planning and Essbase users only: By default, processing of a formula component calculation starts with the first member you enter in the grid. If you want to start processing the formula component calculation with another member, enter the member or function name in Member Block, or click the Ellipsis icon to pick one from the Member Selector. See About Adding Members and Functions to a Component.

  13. In Comment, enter comments for the conditional and formula statements you want to create.

  14. Optional: To create a conditional statement (that is, an IF statement) for the formula component, click Add Condition. See Using the Condition Builder to Create Conditional Statements (Financial Management, Planning, and Essbase Block Storage Application Users Only).

  15. Optional: In the IF row that is displayed, enter the text of the condition statement, or click the Add/Edit condition icon in the right column of the row to access the Condition Builder. The Condition Builder enables you to design a condition statement graphically.

    Note:

    Though you can select IF, ELSE IF, and ELSE from the down arrow, by default, the first statement must be an IF statement.

  16. Optional: Use the Condition Builder to design the IF conditional statement. See Using the Condition Builder to Create Conditional Statements (Financial Management, Planning, and Essbase Block Storage Application Users Only).

  17. In the Formula row, to create a formula statement, click in the row to the left of the equal sign. Select the Actions icon, and select:

    Note:

    If you created a conditional statement (that is, an IF statement) in step 14 through step 16, the formula statement you create in this step is the THEN statement of the condition.

  18. In the Formula row, to complete the formula statement, click in the row to the right of the equal sign. Click the Actions icon, and select:

  19. Financial Management users only: For each statement, click the Logging Information icon to enter an optional condition statement for the log; the log information is written to the log file only if the condition is met. After you save the logging information, the Comments icon is displayed with horizontal lines to indicate that there is log text. See Entering Logging Information for Formula Statements (Financial Management Users Only).

    Note:

    You need to select Enable Logging to include the log text in the log file.

  20. Click the Comments icon to enter comments about the calculation statement row. Click OK.

  21. Optional: If you want to create another IF statement, or an ELSE IF or ELSE statement, complete these steps:

    1. Click Add Condition.

    2. Click the down arrow, and select one of these options:

      • IF: select this to create an IF conditional statement. If the IF statement is TRUE, then actions are performed; if the IF statement is FALSE, then other actions are performed.

      • ELSE IF: select this to create an ELSE IF conditional statement. The actions in this statement are performed if there is an associated IF statement and the IF statement is FALSE.

      • ELSE: select this to create an ELSE conditional statement. The actions in this statement are performed if there is an associated ELSE IF statement and the ELSE IF statement is FALSE.

        Note:

        If you remove the condition statement from an IF or ELSE IF block, and if the next block contains an ELSE IF statement, then the next block is changed to an IF block. However, if the next block contains an ELSE statement, then the condition statement in this block is removed.

    3. Repeat step 14 through step 20 to design additional statements for the formula component. A formula grid can consist of one or more formula blocks that contain a collection of formula statements. You can also enter a comment and a condition for the block, though this is optional.

      Tip:

      If necessary, click the + icon to add more formula rows.

  22. Users creating a formula component for a business rule only: On Usages, you can view the rules that use the formula component.

    Note:

    None of the information on this tab can be edited.

  23. Select File, Save.