Skip to main content
Romario
Newcomer
May 11, 2023 7:37 AM UTC

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

4 replies

AndreaF
Expert
May 11, 2023 9:39 AM UTC

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
    Newcomer
    May 11, 2023 2:15 PM UTC

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

    Employee - Sage
    JackLacavaEmployee - Sage
    Employee - Sage
    May 13, 2023 6:17 AM UTC

    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
    Newcomer
    May 17, 2023 5:52 PM UTC

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

    Terms & ConditionsAccessibility statement