Impact of dimension changes on cube data
Changes to a dimension can impact the data in the dependent cubes.
These are the XML functions that can cause dimension changes:
- Dimension Write
- Dimension UpdateHierarchies
- Dimension RenameElements
If an affected cube is already loaded into memory, the changes are applied immediately. Otherwise, the changes are applied the next time the cube is loaded.
This table shows how dimension changes affect cube data:
| Dimension change | Cube data |
|---|---|
| Removal of base or string elements. | The cell values and cell notes of the corresponding coordinates are removed. |
| Removal of consolidated elements. | The cell notes of the corresponding coordinates are deleted. |
| Removal and re-addition of base elements with identical names within a single request. | The cell values and cell notes are retained.
Note: Calculations in dependent cubes might change.
|
Renaming elements using the Dimension RenameElements function. |
The cell values and cell notes are retained. |
| Changing the type of elements from base or string to consolidated. | The cell values of the corresponding coordinates are deleted.
The cell notes are retained. |
| Changing the type of elements from consolidated to base or string. | The cell notes are retained. |
| Changing the type of elements from base to string in the last cube dimension. | The cell values at the affected coordinates are retained as numbers, so numeric calculations continue to work. Once these values are overwritten, they are interpreted as strings, and numeric calculations are no longer possible.
The cell notes are retained. |
| Changing the type of elements from string to base in the last cube dimension. | The cell values at the affected coordinates are retained as strings, so numeric calculations do not work. Once these values are overwritten, they are interpreted as numbers, and numeric calculations are possible.
The cell notes are retained. |