1. Administering and Working with Enterprise Profitability and Cost Management
  2. Creating and Managing Applications
  3. Managing Application and System Settings
  4. Calculation Options Settings
  5. Enabling Allocation Rule Non Empty Tuple

Enabling Allocation Rule Non Empty Tuple

The Allocation Rule Non Empty Tuple (NET) setting can improve the calculation times for Simple Reclassification (SR) rules. This setting 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.

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.

To enable Allocation Rule Non Empty Tuple (NET):

  1. From the Home page, select Tools, and then Variables.

  2. On the Variables page, select Substitution Variables.

  3. Click Add icon.

    A new variable is added to the bottom of the list.

  4. Scroll to the bottom of the list, and select the cube where you want to add the variable.

  5. For Name, enter EPCM_CALC_NET_ENABLE.

  6. For Value, enter "Yes".

  7. Click Save.

Note:

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