Forum Discussion
Delete Multiple Members using Extender Rule
All - The below extender rule will be able to delete multiple member from Parent Hierarchy.
1. Provide the Dimension Name & Top Parent Name in the Hierarchy - See highlighted in Red.
2. I want t...
I came up with the following solution, which seemed to be the simplest:
Dim d As [Dim] = BRApi.Finance.Dim.GetDim(si, "UDDimension")
Dim m As Member = BRApi.Finance.Members.GetMember(si, d.DimPk.DimTypeId, xfRow.OriginalDataRow("MemberName"))
Dim sql As String = "SELECT TOP 1 * FROM vDataRecordAll Where UD4Id = '" & m.MemberId & "'"
Dim dt As DataTable = BRApi.Database.ExecuteSql(dbConn, sql, False)
If dt.Rows.Count <> 1 Then
BRApi.Finance.MemberAdmin.RemoveMember(si, d.DimPk, m.MemberPk)
End If
JackLacava
OneStream Employee
OneStream EmployeeI think that should do, although in theory you might want to check one of the Stage views too, on the target columns.