Testing Optional Calculation Method Enhancements

Standard Oracle Hyperion Profitability and Cost Management calculation processes are designed to yield consistent and reliable calculation results. Profitability and Cost Management offers Logical Clear Enhancement and Allocation Rule Non Tuple Enhancement optional calculation settings that may help enhance performance in some cases. These should be carefully tested for possible regressions of both performance and validity of the calculated results before promoting them to a production environment.

Logical Clear Enhancement

The Logical Clear Enhancement can help improve the overall calculation times when the data growth in the database impacts database clear processes. For detailed information, see Managing Historical Data Volumes with a Reporting System.

Oracle recommends enabling this calculation enhancement if the application starts to demonstrate an overall slowdown in calculation times for all rules and minimizing the data volumes does not improve performance.

Tip:

You can use the EPCM_CALC_CLEAR_TYPE substitution variable to specify whether to use Physical or Logical clear. The valid values for this substitution variable are Logical or Physical. When this variable is not present, the default is Logical. See Defining Logical Versus Physical Clear in Enterprise Profitability and Cost Management Administering and Working with Enterprise Profitability and Cost Management.

Allocation Rule Non Empty Tuple Enhancement

The Allocation Rule Non Empty Tuple (NET) enhancement can improve the calculation times for Simple Reclassification (SR) rules. This enhancement may be the solution if you experience long run times for SR rules with very large and very sparse source or destination ranges. In some cases the allocation logic of the affected rules is conducive to improvements while in others it is not. Regression testing is critical before promoting this calculation enhancement to a production environment.

Tip:

You can use the EPCM_CALC_NET_ENABLE substitution variable to enable Allocation Rule Non Empty Tuple (NET). The valid values for this substitution variable are Yes or No. When this variable is not present, the default is No. See Enabling Allocation Rule Non Empty Tuple in Enterprise Profitability and Cost Management Administering and Working with Enterprise Profitability and Cost Management.