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. However, when you add a Dynamic Calc and Store member to a dense dimension, Essbase does reserve space in the relevant data blocks for the member’s values and, therefore, must restructure the database.
When you add a Dynamic Calc or a Dynamic Calc and Store member to a sparse dimension, Essbase updates the index but does not change the relevant data blocks. See Index Manager.
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.
Essbase does restructure the database if the member is Dynamic Calc and Store.
Change the storage property of a dense dimension member from Dynamic Calc and Store member to a nondynamic storage property.
Change the storage property of a sparse dimension Dynamic Calc or Dynamic Calc and Store member to a nondynamic storage property.
In the following cases, Essbase does not restructure the database but does restructure the database index, which is significantly faster:
In the following cases, Essbase restructures the database:
Add, delete, or move a dense dimension Dynamic Calc and Store member.
Essbase does not restructure the database if the member is Dynamic Calc.
Change a dense dimension Dynamic Calc and Store member to a Dynamic Calc member.
Change a dense dimension Dynamic Calc member to a Dynamic Calc and Store member.
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 Dynamic Calc or Dynamic Calc and Store.