Calculation Commands

Calculate routines are executed for a specified intersection of scenario, year, period, entity, and value. Executing Calculate routines results in writing or clearing data in the current data table, which corresponds to the current intersection of scenario, year, period, entity, and value. When users execute Calculate routines, the system can read data from anywhere in the application. However, data is only written to the current data table.

Note:

The calculate routine will fail if the [None] entity exists in a hierarchy when you consolidate.

You run these processes in data grids by selecting one of these commands:

• Calculate

• Force Calculate

• Calculate Contribution

• Force Calculate Contribution

• Consolidate

• Consolidate All With Data

• Consolidate All

• Translate

• Force Translate

When you select a calculation command, Oracle Hyperion Financial Management executes the Sub Calculate() routine in the RLE file. The Calculate() routine calculates accounts and custom dimension members for a specified Entity-Value combination within a specified Scenario, Year, and Period.