Restructuring Databases
When you add a Dynamic Calc member to a dense dimension, Essbase does not reserve space in the data block for the member’s values. Therefore, Essbase does not need to restructure the database.
When you add a Dynamic Calc member to a sparse dimension, Essbase updates the index but does not change the relevant data blocks.
Essbase can save changes to the database outline significantly faster if it does not have to restructure the database.
In the following cases, Essbase does not restructure the database or change the index (Essbase saves only the database outline, which is very fast):
-
Add, delete, or move a dense dimension Dynamic Calc member.
-
Change the storage property of a sparse dimension Dynamic Calc member to a nondynamic storage property.
-
Rename any Dynamic Calc member.
In the following cases, Essbase does not restructure the database but does restructure the database index, which is significantly faster:
-
Add, delete, or move sparse dimension Dynamic Calc members.
In the following cases, Essbase restructures the database:
-
Change the storage property of a nondynamic member in a dense dimension to Dynamic Calc.
-
Change the storage property of a dense dimension from Dynamic Calc member to a nondynamic value.
-
Change the storage property of a nondynamic member in a sparse dimension to Dynamic Calc.