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
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...
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...?
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>