Preferences Related to Calculation Performance

There are three calculation performance related preferences in Enterprise Profitability and Cost Management that can be used to alter calculation performance characteristics and behavior in certain special cases. Each preference can be set or changed by creating a substitution variable. When creating the substitution variable, be sure to create it for"All Cubes".

The default values shown in the table do not require the creation of a substitution variable.

Table 11-3 Preferences Related to Calculation Performance

Variable Name	Default Value	Description / When to Use	Behavior
EPCM_CALC_NET_ENABLE	No	"NET" is for "nonempty tuple" Allocation rules on sparse cubes may perform better by setting this preference to "Yes". Not all Enterprise Profitability and Cost Management applications will see a performance benefit from enabling this preference. Note: This affects Allocation Rules only, Custom Calculation rules are not impacted by this setting.	No (default): All applicable cells in rule ranges are considered during the calculation. Yes: Cells with no values are ignored/skipped during the calculations.
EPCM_CALC_USE_SCRATCH_CELLS	Yes	An enhancement in the calculation algorithm generally improves performance for certain types of Allocation rules. In rare cases, Allocation rules can be out of balance due to this enhancement. If you detect out-of-balance rules, use this variable to disable the enhancement, and report the issue to Oracle Support.	Yes (default): The calculation performance enhancement is enabled, which may offer better calculation performance. No: The calculation performance enhancement is disabled.
EPCM_ENABLE_JAPI_CONNECTION_POOL	Yes	This variable is for an enhancement that improves the management of Oracle Essbase connections during calculation. The enhancement generally improves stability and may improve performance during high-concurrency calculations. It is now enabled by default; you can use this variable to disable it if directed to do so by Oracle Support.	Yes (default): The Essbase connections enhancement is enabled. No: The Essbase connections enhancement is not enabled.

Variable Name

Default Value

Description / When to Use

Behavior

EPCM_CALC_NET_ENABLE

"NET" is for "nonempty tuple" Allocation rules on sparse cubes may perform better by setting this preference to "Yes". Not all Enterprise Profitability and Cost Management applications will see a performance benefit from enabling this preference.

Note: This affects Allocation Rules only, Custom Calculation rules are not impacted by this setting.

No (default): All applicable cells in rule ranges are considered during the calculation.

Yes: Cells with no values are ignored/skipped during the calculations.

EPCM_CALC_USE_SCRATCH_CELLS

Yes

An enhancement in the calculation algorithm generally improves performance for certain types of Allocation rules. In rare cases, Allocation rules can be out of balance due to this enhancement. If you detect out-of-balance rules, use this variable to disable the enhancement, and report the issue to Oracle Support.

Yes (default): The calculation performance enhancement is enabled, which may offer better calculation performance.

No: The calculation performance enhancement is disabled.

EPCM_ENABLE_JAPI_CONNECTION_POOL

Yes

This variable is for an enhancement that improves the management of Oracle Essbase connections during calculation. The enhancement generally improves stability and may improve performance during high-concurrency calculations. It is now enabled by default; you can use this variable to disable it if directed to do so by Oracle Support.

Yes (default): The Essbase connections enhancement is enabled.

No: The Essbase connections enhancement is not enabled.