Dynamically calculating some database values can significantly improve the performance of an overall database calculation.
By calculating some data values dynamically, you reduce:
Batch calculation time of the database, because Essbase has fewer member combinations to calculate.
Disk usage, because Essbase stores fewer calculated data values. Database size and index size are also reduced.
Database restructure time. For example, adding or deleting a Dynamic Calc member in a dense dimension does not change the data block size, so Essbase does not need to restructure the database. See Restructuring Databases.
Time required to back up the database. Because database size is reduced, Essbase takes less time to perform a backup.
Data values that Essbase calculates dynamically can take longer to retrieve. You can estimate the retrieval time for dynamically calculated members. See Reducing the Impact on Retrieval Time.