Identify Additional Calculation Optimization Issues

The relationship between Essbase block storage calculation and performance is also described in topics about Dynamic Calc, developing calculation scripts, and partitioning. Links are provided for reference.

• In Dynamically Calculating Data Values, see the following topics:

  • Benefitting from Dynamic Calculation

  • Reducing the Impact on Retrieval Time

  • Dynamically Calculating Data in Partitions

• In Develop Calculation Scripts for Block Storage Cubes, see the following topics:

  • Specify Global Settings for a Calculation

  • Use Calculation Scripts on Partitions

When you convert currencies using the CCONV command, the resulting data blocks are marked as dirty for the purposes of Intelligent Calculation. This means that Essbase recalculates all the converted blocks when you recalculate the cube. .