Remove Attribute Tags from Levels, Accounts, and Dimensions
- Levels, accounts, or custom dimensions that you tagged with attribute values.
- Security:Model includes sheets, accounts, dimensions, and formulaspermission.
The fastest way to remove attribute tags is to delete the attribute value. When you delete the attribute value, it automatically gets removed from the accounts, custom dimensions, and levels. When you want to remove the attribute tag without deleting the attribute value, you can manually remove it in the respective settings. However, manually removing the attribute value 1 at a time can be cumbersome when you must remove the attribute from several accounts, custom dimensions, or levels.
To accomplish your task in-bulk, you can take advantage of the import and export functions.
- SelectModelingfrom the main menu.
- Click the attribute hierarchy.Example:When you must remove attribute from accounts, clickAccount Attributes.
- From the list, highlight the attribute with the value that you want to remove.
- From the toolbar, click button for new attribute values.Example: For account attributes, clickCreate new account attribute value.
- ForNameandCode, enterDeleteand save.
- From the breadcrumb, clickModeling.
- Click the hierarchy that you want to update.Example: To remove tags from general ledger accounts, clickGeneral Ledger Accounts.
- From the toolbar, click the printer button.When the button has a drop-down arrow, select the option to export the structure.
- In the downloaded spreadsheet, enterDeletein place of the attribute values that you want to remove.
- Save the spreadsheet.
- Return to the same hierarchy in theModelingarea.Example: Return toGeneral Ledger Accounts.
- From the toolbar, click the import button.When the button has a drop-down arrow, select the option to import the structure.
- Click theUpdate and Appendoption and select the saved spreadsheet.
- From the breadcrumbs, selectModeling.
- Click the appropriate attribute hierarchy.Example: When you're removing attributes from accounts, clickAccount Attributes.
- Expand the attributes to highlight the newDeletevalue.
- From the toolbar, click the trash icon.
The levels, dimensions, or accounts no longer have a tag for that attribute.