05-11-2023 03:37 AM - edited 05-11-2023 03:44 AM
Hi All,
We have an issue where we are unable to delete an entity member from the hierarchy.
We get this error: "Unable to delete member 'XXXX'. Error removing member. Member 'XXXX' has data.
How can we clean the member 100%, so we can delete it?
Thank you
Romario
05-11-2023 05:39 AM
Hi, the easiest way is to create a Data management step (Application tab/Data management) of "Clear data" type. One of the fields let you filter on Entity so you only clear the data of that entity
05-11-2023 10:15 AM
That's the feature in OS, Metadata cannot be deleted without clearing the data for that member
05-13-2023 02:17 AM
Before.you set up a DM job, if you're trying to identify where the entity is referenced, you can look in the System/Database page; there is an item that will allow you to query your records across all cubes.
05-17-2023 01:52 PM
If you do need the entity's data as a backup, best to run a DM job to extract the data before deleting (i.e. 'Export Data').