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

jrk's avatar
jrk
New Contributor III
4 years ago

Mass Delete Members below Orphan

I'm looking for an option to mass delete members marked as ORPHANS in a dimension, I tried few options but if there is any data in the application for any of these ORPHAN members the delete fails W...
Finance
ysaead's avatar
ysaead
New Contributor
3 years ago

I currently done have any data for the members under the Orphan member. How do I mass delete those in one shot? Seems like a no brainer but the functionality doesn't exist in app...?

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    3 years ago

    Hi ysaead: you can use the Application Load/Extract functionality to load an XML file that tells OS to delete your target members.  I couldn't find my documentation on this, but the XML file generally looks like:

    <?xml version="1.0" encoding="utf-8"?>
    <OneStreamXF version="6.6.0.12930">
    <metadataRoot>
    <dimensions>
    <dimension type="Account" name="YourAccountDimensionName">
    <members>
    <member name="SomeAccountMemberName" action="delete"/>

    ...repeat the above for more members
    </members>
    </dimension>
    </dimensions>
    </metadataRoot>
    </OneStreamXF>