There are two ways to delete values in a cube: splashing with #0 in a Jedox view and using the "Clear cube..." command in Modeler.
Splashing with #0
In spreadsheet reports, you can delete a single base cell value by writing back a zero in this specific cell. Alternatively, you can use the splashing command #0 to write back zeros to a parent cell and all its children at once.
"Clear cube..." command
If you right-click on a cube in the Modeler, you can select Clear cube... from the context menu:
To limit clearing to only the elements a user has rights to, double-click the dimension to select specific elements, then use Clear selection. Clear selection checks the user's rights against each selected element, the same check performed during splashing #0. If the user lacks sufficient rights to an element in the selection, the action returns a permission error instead of clearing it. Jedox recommends that only users with full access to the cube use Clear All.
The screenshot below shows the selection of the year "2018":
Click OK to return to the Clear cube dialog. If your selection is not correct, click the Reset selection button. If your selection is correct, click the Clear selection button. You will receive a message when the procedure is complete. The larger the selection or cube, the longer clearing can take (up to a few minutes).
You may need to refresh an existing view to see that your Clear cube ... command was successful.
Related articles:
Updated September 24, 2026