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...
Forum Discussion
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
I think that should do, although in theory you might want to check one of the Stage views too, on the target columns.