Restructuring a Database
When you restructure a database (for example, by adding a member to a dense dimension), data blocks may need recalculating.
Oracle Essbase marks all data blocks as dirty. When you calculate the restructured database, all blocks are calculated.
Note:
You can restructure block storage application databases.
In the following cases, you should restructure the database:
-
Add, delete, or move a dense dimension Dynamic Calc and Store member.
-
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.
To restructure a database: