Outline Change Quick Reference

Certain outline changes have an impact on Essbase calculation and restructuring.

Note:

If you are using Partitioning, restructuring affects only the database to which you are connected.

Table 32-2 Actions: Delete, Add, or Move Member

Action	Calculation / Restructure Effects
Delete member of sparse dimension	Data must be recalculated to reflect changes to relationships. Essbase deletes from the index file all pointers to blocks represented by the deleted member. Because the blocks are no longer pointed to, they become free space. No restructure.
Delete member of attribute dimension	None
Delete member of dense dimension	Data must be recalculated to reflect changes to relationships. Essbase restructures the data files to reflect a changed block size. Essbase restructures the index.
Delete shared member in sparse or dense dimension	Data must be recalculated. The data remains associated with the prototype member name, but, because the parent of the shared member may have depended on child data, recalculation is needed. No restructure.
Add member to sparse dimension	Data for the new member must be loaded or calculated to derive new values. Essbase restructures the index.
Add member to dense dimension	Data for the new member must be loaded or calculated to derive new values. Data must be recalculated. Essbase restructures the data files to reflect a changed block size. Essbase restructures the index.
Add member to attribute dimension	None
Add shared member to sparse or dense dimension	Data must be recalculated. The new shared member affects the consolidation to its parent. No restructure.
Move regular member within a sparse dimension	Data must be recalculated to reflect changes in consolidation. Essbase restructures the index file.
Move regular member within a dense dimension	Data must be recalculated to reflect changes in consolidation. Essbase restructures index and data files.
Move an attribute dimension member	None

Table 32-3 Actions: Other Member-Related Changes

Action	Calculation / Restructure Effects
Change a member alias or add an alias to a member	None
Rename member	None
Change member formula	Data must be recalculated to reflect formula changes. No restructure.

Action

Calculation / Restructure Effects

Change a member alias or add an alias to a member

None

Rename member

None

Change member formula

Data must be recalculated to reflect formula changes.

No restructure.

Table 32-4 Actions: Dynamic Calculation-Related Changes

Action	Calculation / Restructure Effects
Define regular dense dimension member as Dynamic Calc	Essbase restructures both index and data files.
Define sparse dimension Dynamic Calc member as regular member	No restructure
Define sparse dimension regular member as Dynamic Calc	Essbase restructures index and data files.
Define dense dimension Dynamic Calc member as regular member	Essbase restructures index and data files.
Define dense dimension regular member as Dynamic Calc member	Essbase restructures index and data files.
Add, delete, or move sparse dimension Dynamic Calc member	Essbase restructures index files.
Add, delete, or move dense dimension Dynamic Calc member	No restructure.

Table 32-5 Actions: Property and Other Changes

Action	Calculation / Restructure Effects
Change dense-sparse property	Data must be recalculated. Essbase restructures both index and data files.
Change label only property	Data must be recalculated. Essbase restructures index and data files.
Change shared member property	Data must be recalculated to reflect the changed data value of the child. Essbase restructures both index and data files.
Change properties other than dense-sparse, label, or shared	Data may need to be recalculated to reflect changed consolidation properties, such as changing time balance from first to last.
Change the order of two sparse dimensions	No calculation or data load impact. Essbase restructures the index.
Change the order of dimensions	Data must be recalculated. Essbase restructures both index and data files.
Change the order of attribute dimensions	None
Create, delete, clear, rename, or copy an alias table	None
Import an alias table or set a member alias	None
Change the case-sensitive setting	None
Name a level and generation	None
Create, change, or delete a UDA	None