Skip to main content
Newcomer
May 11, 2023

Unable to delete Entity member

  • May 11, 2023
  • 4 replies
  • 0 views

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

4 replies

Expert
May 11, 2023

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

Newcomer
May 11, 2023

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

OneStream Employee
May 13, 2023

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.

Newcomer
May 17, 2023

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