Remove Dimensions from Cube Sheets
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
I added a dimension to my cube
sheet, but I no longer need it. How can I remove the dimension from the cube?
Answer
To remove a dimension from a Cube sheet, you must delete all data from the
sheet. You can do this by going to the summary page and clicking Erase All Data. If you
do not want to erase all data in the cube, you can make the dimension unavailable on the
Cube sheet. This will delete any data associated with that dimension in the sheet for
all versions.Answer
These type of
update do not get tracked in the Audit Trail because it is data removal due to a
structural change.