Outline Change Quick Reference

The tables in this section show all outline changes that affect calculation and restructuring, including incremental restructuring.

Note:

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

Table 180. Actions: Delete, Add, or Move Member

Action

Calculation and Standard Restructure Effects

Incremental Restructuring Applies? (If Enabled)

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.

For regular members, no. Essbase restructures the index, overriding incremental restructure.

For label-only members, yes, restructuring is deferred.

Delete member of attribute dimension

None

No

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.

Yes. Restructure deferred.

Delete shared member in sparse or dense dimension

Data must be recalculated. The data remains associated with the original member name, but, because the parent of the shared member may have depended on child data, recalculation is needed.

No restructure.

No

Add member to sparse dimension

Data for the new member must be loaded or calculated to derive new values.

Essbase restructures the index.

Yes. Restructure deferred.

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.

Yes. Restructure deferred.

Add member to attribute dimension

None

No

Add shared member to sparse or dense dimension

Data must be recalculated. The new shared member affects the consolidation to its parent.

No restructure.

No

Move regular member within a sparse dimension

Data must be recalculated to reflect changes in consolidation.

Essbase restructures the index file.

No. Essbase restructures the index file, overriding incremental restructure.

Move regular member within a dense dimension

Data must be recalculated to reflect changes in consolidation.

Essbase restructures index and data files.

Yes. Restructure deferred.

Move an attribute dimension member

None

No

Table 181. Actions: Other Member-Related Changes

Action

Calculation and Standard Restructure Effects

Incremental Restructuring Applies? (If Enabled)

Change a member alias or add an alias to a member

None

No

Rename member

None

No

Change member formula

Data must be recalculated to reflect formula changes.

No restructure.

No

Table 182. Actions: Dynamic Calculation-Related Changes

Action

Calculation and Standard Restructure Effects

Incremental Restructuring Applies? (If Enabled)

Define Dynamic Calc member as Dynamic Calc and Store

For dense dimension members: Essbase restructures both index and data files.

For sparse dimension members: no restructure.

Yes. Restructure deferred.

Define Dynamic Calc and Store member as Dynamic Calc

None

No

Define regular dense dimension member as Dynamic Calc and Store

None

No

Define regular dense dimension member as Dynamic Calc

Essbase restructures both index and data files.

Restructure deferred.

Define sparse dimension Dynamic Calc and Store member or Dynamic Calc member as regular member

No restructure

No

Define sparse dimension regular member as Dynamic Calc or Dynamic Calc and Store

Essbase restructures index and data files.

Yes. Restructure deferred.

Define dense dimension Dynamic Calc and Store member as regular member

No restructure

No

Define dense dimension Dynamic Calc member as regular member

Essbase restructures index and data files.

Yes. Restructure deferred.

Define dense dimension regular member as Dynamic Calc member

Essbase restructures index and data files.

Yes. Restructure deferred.

Add, delete, or move sparse dimension Dynamic Calc member

Essbase restructures index files.

For member add or delete, restructure is deferred.

For member move, Essbase restructures index files, overriding incremental restructure.

Add, delete, or move sparse dimension Dynamic Calc and Store member

Essbase restructures index files.

For member add, restructure deferred.

For member move or delete, Essbase restructures index files (overrides incremental restructure).

Add, delete, or move dense dimension Dynamic Calc and Store member

Essbase restructures index and data files.

No

Add, delete, or move dense dimension Dynamic Calc member

No restructure.

No

Table 183. Actions: Property and Other Changes

Action

Calculation and Standard Restructure Effects

Incremental Restructuring Applies? (If Enabled)

Change dense-sparse property

Data must be recalculated.

Essbase restructures both index and data files.

Essbase restructures index and data files overriding incremental restructure.

Change label only property

Data must be recalculated.

Essbase restructures index and data files.

Restructure deferred.

Change shared member property

Data must be recalculated to reflect the changed data value of the child.

Essbase restructures both index and data files.

Restructure deferred.

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.

No

Change the order of two sparse dimensions

No calculation or data load impact.

Essbase restructures the index.

Essbase restructures the index, overriding incremental restructure.

Change the order of dimensions

Data must be recalculated.

Essbase restructures both index and data files.

Essbase restructures index and data files (overrides incremental restructure).

Change the order of attribute dimensions

None

No

Create, delete, clear, rename, or copy an alias table

None

No

Import an alias table or set a member alias

None

No

Change the case-sensitive setting

None

No

Name a level and generation

None

No

Create, change, or delete a UDA

None

No