Profitability and Cost Management Settings

Table 4-11 Profitability and Cost Management Settings

Setting Description
Calculation Threads

The number of rules that can be executed in parallel if a rule set is enabled for parallel calculation. See Parallel Calculation in the Rule Set Calculation options in Creating a Rule Set.

Allocation Precision

The decimal precision for calculated allocation results. Precision is calculated by rounding, not truncation. The default is 2 decimal places. Values can range from 7 to -6.

Allocation Rules Use Non Empty Tuple

Indicates whether Non Empty Tuple (NET) optimization is enabled. 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. Regression testing is critical before promoting this calculation enhancement to a production environment.

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

Tip: For information on skipping empty tuples in custom rules, see Skipping Empty Tuples to Optimize Calculations.

Skip Scripts When Data Missing

Indicates whether Skip Scripts optimization is enabled. Select Yes to allow allocation rules to skip processing steps when data conditions make them unnecessary, thus improving performance.

Skip Scratch Cell Generation

Indicates whether scratch cell optimization is enabled. Select Yes to skip unnecessary rule execution steps and improve allocation rule performance.

Note: In rare cases, allocation rules can be out of balance if you skip scratch cell generation. If you detect out-of-balance rules, select No, and report the issue to Oracle Support.

Scenario Upper Level Start / End Years Replaced with Level Zero

Resolves parent Year members in Scenario dimensions, which are used to determine whether the data for those scenarios can be edited.

  • If Yes, and All Years is selected in the Scenario dimension Start Year or End Year, then the Years dimension automatically resolves to all years configured and allows you to edit the cell level data for the given scenario.

  • If No, you cannot edit cell level data when All Years is used.

The default value is Yes. Selecting Yes guarantees that when the Start Year and End Year is set to All Years, any future years are automatically resolved to the correct year; otherwise, you would need to keep changing the End Year when new years are introduced.