Remove Dimension Values from Derived Dimensions with Import

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.

When you must only remove mappings from a few of the dimension values, you can use the import function with the Reload Mapping(s)
option.

When you must remove all the mappings of a dimension, you must remove the mappings in Dashboards. See Steps: Remove Dimension Values from Derived Dimensions in Dashboards.

From the main menu, select

Modeling

Click

Dimensions

From the list of dimensions, highlight the dimension.

From the toolbar, click the arrow next to the print button and select Export Dimension Mapping
.

Select the version from the prompt.

Click Download
.

Open the spreadsheet that downloads to your computer.

Find all occurrences of the dimension value using the spreadsheet Find function.

Either replace the dimension value or delete the entire row with the dimension value, which also deletes the rule.

Save the spreadsheet.

Return to

Modeling

Dimensions

From the dimension list, highlight the same dimension.

From the toolbar, click the arrow next to the import button and select Import Dimension Mapping
.

Use the

Reload Mapping(s)

import option.

You have removed the mappings. Mappings are a dependency that prevents you from deleting dimension values. After you remove the mappings, the dependency is resolved. You can delete the dimension value when all dependencies have been resolved. You can also disable the Use mapping criteria to set dimension value on modeled sheets
check box for the dimension if you have removed all mappings.