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
4 years agoNew Contributor III
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
Wanted to know if there is a work around or another way to achieve this & also to know if we can delete member without clearing the data
5 Replies
- db_pdxValued Contributor
"if there is any data in the application for any of these ORPHAN members the delete fails"
That is by design; you cannot delete members that contain data. If you want to delete these members you need to clear the data from them first.
-DB
- jrkNew Contributor III
Cleared the data now to delete these members
Was trying to get the parent member ID for one of the orphan members ID and then wanted to delete all the members below that parent member ID. But somehow the below output returns blank, looks like ORPHAN members doesn't have any parent ID even though they are grouped in one place in the hierarchy
Is there a way to identify the ORPHAN members?
Dim objDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "Location")
Dim objDimDisplayOptions As New DimDisplayOptions()
Dim objList As List(Of Member) = BRApi.Finance.Members.GetParents(si, objDimPk, objID, False, objDimDisplayOptions)
brapi.ErrorLog.LogMessage(si, objList(0).tostring) - ysaeadNew Contributor
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_pdxValued Contributor
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>
- OscarContributor
is there a business rule to generate a list of Account members in the Orphan folder?
Related Content
- 3 years ago
- 1 month ago