Remove Dimension Values from Allocation Formulas
Security:
Allocation Rules
permission.When allocation weight formulas or formulas reference a dimension value, you might consider updating the formula before you delete the dimension value. Otherwise, the formulas in the allocation rule returns errors that might affect your downstream data. The name of the allocation rule displays in the
Allocations Rules
tab of the View Dependency
table. See Resolve View Dependencies to Delete Dimension ValuesYou can still change the formulas to remove the errors after you delete the dimension value. It won't be as easy to find the rule that has the error though.
- SelectModelingfrom the main menu.
- ClickAllocation Rules.
- Click the pencil icon next to the rule that has the name indicated in theAllocation Rulestab.
- Click theDefinitiontab.
- Remove the dimension value from theWeight Formula.
- Remove the dimension value from theFormulafield in theAllocate-Out Valuesection.