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
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
That's the feature in OS, Metadata cannot be deleted without clearing the data for that member
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.
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').
