06-07-2022
01:41 PM
- last edited
a month ago
by
JackLacava
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
06-07-2022 03:41 PM
"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
06-09-2022 10:13 AM
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)
08-01-2022 12:39 PM
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...?
08-01-2022 01:00 PM
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>
09-21-2022 11:27 AM
is there a business rule to generate a list of Account members in the Orphan folder?