Skip to main content
Newcomer
Jun 7, 2022 5:41 PM UTC

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

Contributor
Jun 7, 2022 7:41 PM UTC

"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

jrkAuthor
Newcomer
Jun 9, 2022 2:13 PM UTC

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)

Newcomer
Aug 1, 2022 4:39 PM UTC

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

Contributor
Aug 1, 2022 5:00 PM UTC

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>

Contributor
Sep 21, 2022 3:27 PM UTC

is there a business rule to generate a list of Account members in the Orphan folder?