Zum Hauptinhalt wechseln
Dokumentation
Dokumentation
Adaptive Planning
Remove Dimension Value Splits from Standard Sheets

Remove Dimension Value Splits from Standard Sheets

You might have many reasons to remove dimension splits from standard sheets. 1 reason could be that you want to delete a custom dimension value that's in use. Dependencies in the
Standard Data
 tab of the
View Dependencies
 table means that dimension values tag data in standard sheets. You can find the dimension values in the splits of the standard sheets. To delete the dimension value or the dimension, you must first remove the association from the standard sheet, or delete the splits.
  1. Find the standard sheets that have the account.
    Security:
    Model includes: sheets, accounts, dimensions, and formulas
     permission.
  2. Select
    Sheets
     from the main menu and open the sheet that has the account.
  3. From the main toolbar, select a version.
    When you're resolving
    Standard Data
     dependencies for custom dimension values, select the same version indicated in the
    Standard Data
     tab.
  4. From the sheet toolbar, select a level.
    When you're resolving
    Standard Data
     dependencies for custom dimension values, select the same level indicated in the
    Standard Data
     tab.
  5. Expand the account to display the splits.
    When you're resolving
    Standard Data
     dependencies for custom dimension values,  search for the name of the same account indicated in the
    Standard Data
     tab.
  6. For each row with the dimension value, click any cell in the row.
  7. From the toolbar, click
    Delete Split
    . Or, to save the data, select a different dimension value for the split.
  8. Save the sheet.
When you're resolving dependencies, you can continue to resolve the other dependencies. When standard data is the only dependency, you can delete the dimension value. See Resolve View Dependencies to Delete Dimension Values.