Unable to delete Entity member

[Romario]

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

[AndreaF]

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

[jrk]

That's the feature in OS, Metadata cannot be deleted without clearing the data for that member

[JackLacava]

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.

[NaeemPathan]

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').