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 Managersupport

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