Delete Unused Dimensions Values in Bulk

Security:

Model includes: sheets, accounts, dimensions, and formulas
permission.

Structure Import
permission.

The

Remove

import option lets you delete only the unused dimension values that you include in your import file. Unused dimension values are either:

Not being used at all in the model.

Being used in ways that don't block you from removing them. Example: They might be in a report.

The import leaves dimension values that are in-use alone. Used dimension values display with blue dots in the dimension list. The blue dot means that you must resolve dependencies before removing the dimension value.

We recommend that you resolve all dependencies before you remove any dimension value, even when it's not required.

Select

Modeling

from the main menu.

Click

Dimensions

From the toolbar, click 1 of these buttons. As you complete the task, consider:

选项	描述
Generate printable view	Downloads existing structure. You can import the file without making any changes to remove all unused dimension values.
Import dimension structure	Click Download template to add unused dimension values and the code of the value manually into a blank template. Instructions are in the first tab of the template.

Make changes to the template or export and save it.

Return to

Modeling

Dimensions

From the toolbar, click

Import dimension structure

Select the Remove
option.

Select your file and click

Upload

When you imported the exported file without making any changes to it, the import deletes all unused dimension values.

When you entered specific dimension values, the import deletes only the dimension values you entered in the spreadsheet if you:

Filled out the template correctly.

Didn't include dimension values that are in use.

When you deleted all the values of a dimension, consider also deleting the dimension manually.