The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Romario's avatar
Romario
New Contributor
3 years ago

Unable to delete Entity member

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

Metadata

4 Replies

  • AndreaF's avatar
    AndreaF
    Contributor III
    3 years ago

    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's avatar
    jrk
    New Contributor III
    3 years ago

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

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    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's avatar
    NaeemPathan
    New Contributor III
    3 years ago

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