Remove Dimension Values from Cube-Entry Formulas
- Required for resolvingCube Entriesdependencies for custom dimension values: Take note of the version, the level, and the account listed in the tab. SeeResolve View Dependencies to Delete Dimension Values.
- Security:Editable Sheet Accesspermission.
You might have many reasons to remove formulas that refer to a dimension value from cube sheets. 1 reason could be that you want to delete a custom dimension value that's in use. Dependencies in the
Cube Entries
tab of the View Dependencies
table means that someone entered a formula in the cell of a cube sheet, and the formula referred to the custom dimension values.Having dependencies in
Cube Entries
doesn't prevent you from deleting the dimension value. However, the cube sheet displays errors for any cell that referenced the deleted dimension. You can prevent these errors by resolving the dependency before you delete the dimension value. - SelectSheetsfrom the main menu.
- Use the account prefix indicated in theCube Entriestab to find the sheet name, and open the sheet.
- From the main toolbar, select the version indicated in theCube Entriestab.
- From the sheet toolbar, clickChange Dimensions.
- Use the account, time period, level, and custom dimensions indicated in theCube Entriestab to change the filters.
- You can replace the formula with the calculated value to save the data. Or, you can update the formula.