Contents
What is restructuring the database?
When you restructure a database (for example, by adding a member to a dense dimension), data blocks may need recalculating. Therefore, Essbase marks all data blocks as dirty. When you calculate the restructured database, all blocks are calculated.
What is the role of a primary key in database designs?
A piece of data that is capable of uniquely identifying a database row is known as a primary key. A primary key is an attribute the values of which are (and always will be) unique for every single row in the database. We recommend that every database table you design have a primary key, without exception.
Can we set varchar as primary key?
It is perfectly acceptable to use a varchar column as the primary key. This is often the case when one uses a natural key that doesn’t happen to be an integer. Keep in mind that even if you introduce a surrogate as the pimary key, you’ll still need to create a unique constraint on product_id.
How to do a restructure of a database?
To restructure a database: From the System View, click the Database Properties icon. In the Enterprise View, expand the Planning application type, the application, and the plan type whose database you want to restructure. Right-click the plan type, and select Restructure Database. Confirm whether you want to restructure the database.
What happens when you disabling incremental restructuring in a database?
If you are using LROs in a database, incremental restructuring is automatically disabled on that database. Disabling incremental restructuring does not affect other databases on the server. Certain member additions and certain changes to sparse dimensions can also trigger immediate restructuring. See Outline Change Quick Reference.
How to avoid database restructure in Oracle Essbase?
For information about clearing data and thus avoiding some restructuring, see CLEARDATA and CLEARBLOCK in the Oracle Essbase Technical Reference or Clearing Data in the Oracle Essbase Administration Services Online Help. This section describes the two ways that a database restructure is triggered.
How to restructure a block storage application database?
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.