Forum Discussion

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