Skip to main content
Documentation
Documentation
Adaptive Planning
Remove Dimension Values from Derived Dimensions

Remove Dimension Values from Derived Dimensions

Security:
  • Structure Import
     permission.
  • Model includes: sheets, accounts, dimensions, and formulas
      permission.
You might have many reasons to remove dimension values from mapping rules. 1 reason could be that you want to delete the dimension value. When dimension values have dependencies in the
Derived Dimensions
 tab, it means that the dimension values are part of mapping rules for derived dimensions. To delete the dimension value or the dimension, you must first change or delete the mapping rule.
  1. From the main menu, select
    Modeling
    .
  2. Click
    Dimensions
    .
  3. From the toolbar, click the arrow next to the print button and select
    Export Dimension Mapping
    .
  4. Open the spreadsheet that downloads to your computer.
  5. Find all occurrences of the dimension value using the spreadsheet Find function.
  6. Either replace the dimension value or delete the entire row with the dimension value, which also deletes the rule.
  7. Save the spreadsheet.
  8. Return to
    Modeling
    Dimensions
    .
  9. From the toolbar, click the arrow next to the import button and select
    Import Dimension Mapping
    .
  10. Use the
    Update and Append
     import function.
When you're resolving dependencies, you can continue to resolve the other dependencies. When derived dimensions are the only dependency, you can delete the dimension value. See Resolve View Dependencies to Delete Dimension Values.