Designing a Formula Component
You can create a formula component from the System View or any other 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.
Note:
Formula components can be used in Oracle Hyperion Financial Management, Oracle Hyperion Planning, and Oracle Essbase block storage business rules and custom templates.
To create a formula component:
- Enter a name, application type, and application to which the formula component belongs, or accept the defaults. Then do one of the following:
-
Financial Management users only: If you are creating a Financial 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.
-
- 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.
- 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.
- 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.
- 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.
- 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.