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.

Modeler Impacts

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.

Advanced Modeler Impacts

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

If the dimension you have deleted is used in a data action, you can still save the model. However, make sure to consider the following impacts:
  • 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
Data Auditing
After you’ve deleted a dimension from a model this dimension will also be removed from data audit table.
Commenting
After you’ve deleted a dimension from a model, each comment entered on members of that dimensions are deleted.
Data Acquisition
Any import job with a mapping based on the dimension you’ve deleted is no longer valid. Make sure to redesign the import job manually.
Story Widgets

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.