Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
3 years ago

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...
Finance
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi all

I'm using the BRApi.Finance.MemberAdmin.RemoveMember to remove a UD4 member which works well.

I was wondering if you had any suggestions on what the best way to check on whether there is information stored against the member is?

i.e. is there a built in function or do I need to do a get data cell formula

Thanks,

Mark

MarkBird's avatar
MarkBird
Contributor III
2 years ago

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's avatar
    JackLacava
    Community Manager
    2 years ago

    I think that should do, although in theory you might want to check one of the Stage views too, on the target columns.