Working with On-Demand Rules

On-Demand Rules are ad-hoc rules that can be used for calculations outside of the consolidation process. An administrator can create on-demand rules to be executed by other users at any time.

Users who have launch permissions can invoke on-demand rules from data forms, Oracle Smart View for Office, post-Data Load processing, journal posting, Supplemental Data posting, or from the Rules card. You can verify or adjust an on-demand rule before invoking consolidation, since it is independent from the consolidation process. You can execute calculations regardless of the current calculation status.

Using on-demand rules outside of the consolidation process reduces consolidation time, since these calculations do not need to be repeated for each consolidation. For example, reclassification or adjustments, or loading life-to-date balances and redirecting them to the appropriate Movement members are calculations that may only need to be executed one time. They are not required to be calculated every time a consolidation process is launched.

You can attach on-demand rules to a data form so that you can execute the calculations and verify the results while viewing the data in the form. This method is faster than running a consolidation to view the results.

See Creating On-Demand Rules, and Adding On-Demand Rules to Data Forms.

You can also create customized calculations using Configurable Calculation rules. See Creating Configurable Calculations.

You create both on-demand rules and Configurable Calculation rules in Calculation Manager using Essbase script statements.

• On-demand rules are executed on an as-needed basis outside of the consolidation process.

• Configurable Calculation rules are always executed as part of the consolidation process.

The following table is a summary of the features of On-Demand Rules and Configurable Calculations.

Feature Summary	On-Demand Rules	Configurable Calculations
Rule content created by Administrator	Yes	Yes
No restriction of number of rules created	Yes
Always executed as part of Consolidation Process		Yes
Execute stand-alone on demand	Yes
Execute regardless of existing Calculation Status	Yes
Launch from Data Form/ Smart View /Rules card	Yes
Calculation Manager support	Yes	Yes
Support most Essbase functions	Yes	Yes
Ability to write to Parent Currency		Yes
Ability to write to Elimination Consolidation member		Yes
Ability to write to Intercompany Eliminations Data Source member		Yes
User handling of housekeeping logic (SET, Block, Calc Dim)	Yes
Calculation Status Update	Yes	Yes
Validate and Deploy Rule	Yes	Yes
Import and Export Rule	Yes	Yes
Follow same best practices for rule writing	Yes	Yes