Deleting Dimensions and Managing Dependencies
When deleting dimensions from a model, make sure that you check on potential dependencies to ensure that your model is still valid.
Account Formulas
When deleting a dimension from a model, the calculations that reference that particular dimension are invalid.
Variables
When deleting a dimension from a model, if there are variables with value domain on the deleted dimension, make sure to fix the value domain.
Currency Conversion
When deleting a dimension from a model, if that that dimension is a currency conversion dimension, check the model settings to reset the currency conversion.
Data Locking
When deleting a dimension from a model, if that dimension is part of data locking, the dimension is removed from the driving dimensions. Also, data locking settings of the model are reverted to the default locking state. Make sure to check data locking settings in the model after you’ve deleted the dimension.
Validation Rule
When deleting a dimension from a planning model, if that dimension is the reference dimension that serves as a basis of a validation rule, the rule is deleted.
If the dimension is the only matched dimension, then the validation rule is deleted. If the dimension is one of multiple matched dimension, the validation rule is updated with the remaining dimensions.
Value Driver Tree
If the dimension you have deleted is used in a value driver tree, the value driver tree gets in valid. Warning messages are given in the builder panel to solve the issues.
Data Action
- The copy rules in case of a copy step
- The mapping between dimensions in case of a cross model copy step
- The validity of formulas in case of an advanced formula step
Charts, Input Controls and Story Filters
After you’ve deleted a dimension, the application displays validation errors for charts, dynamic texts, input controls and story filter that relied on that dimension. Warnings are given in the Builder panel to resolve the issues.
Hyperlinks
Hyperlinks with dimension context are still displayed, but they’re inactive. Make sure to fix them manually.
Tables
After you’ve deleted a dimension, tables are updated automatically and show data on an aggregated level. Table filters based on the dimension are no longer valid. Styling rules will adapt to the aggregated view but may need to be adapt.
Cross Calculations
Cross calculations are removed automatically from tables.