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:

1. From the System View, click the Database Properties icon.
2. In the Enterprise View, expand the Planning application type, the application, and the plan type whose database you want to restructure.
3. Right-click the plan type, and select Restructure Database.
4. Confirm whether you want to restructure the database.

   Calculation Manager displays a message letting you know whether the database was restructured successfully.