Allow deletion in shared dimensions

[giacomociti]

Is your feature request related to a problem? Please describe. Deleting a term in a shared dimension (or deleting the entire shared dimension) is not allowed. This prevents breaking cubes which may already refer to the deleted terms. But in a test environment, where frequent adjustments are needed, this limits the development of new shared dimensions.

Describe the solution you'd like A configuration (typically based on the running environment) may enable the deletion of terms in a shared dimension and also the deletion of whole shared dimensions.

Describe alternatives you've considered It's possible to deprecate terms, but during development is more convenient to delete them.

[JurekMueller]

I want to add to this: There are many empty shared dimensions, e.g: https://int.cube-creator.lindas.admin.ch/app/shared-dimensions/https:!!!!politics.ld.admin.ch!!council!!party!!roles https://int.cube-creator.lindas.admin.ch/app/shared-dimensions/https:!!!!politics.ld.admin.ch!!council!!parl-group!!roles https://int.cube-creator.lindas.admin.ch/app/shared-dimensions/https:!!!!ld.admin.ch!!dimension!!electricity-provider https://int.cube-creator.lindas.admin.ch/app/shared-dimensions/https:!!!!politics.ld.admin.ch!!organization!!type!!admin (there are probably more)

Being able to delete them and other relics from development or request their deletion with someone would greatly improve the usability of shared dimensions.

[tpluscode]

Removal of shared dimensions was not included intentionally because once published we cannot be certain that a shared term has not been used somewhere.

That said, at least a manual cleanup on demand is not a bad idea to clear the field a little.