Skip to main content
BCG
Newcomer
May 16, 2023 7:56 AM UTC
Solved

GetMember ID issue

Hi Experts,

I am trying to read the member ID in data buffer to assign some values accordingly, But it is giving in correct ID seems

in the log file i can see ID as "-1" , Generally Member ID was different in the dimension library if this is readying correctly - Kindly confirm

Dim vSrcUD2Split As String() = Split(sText2,":")
Dim GetUD1Ac As String = Trim(vSrcUD2Split(0)):Dim GetUD1Mvt As String = Trim(vSrcUD2Split(1))
Dim vTgtActID As Integer = api.Members.GetMember(DimType.Account.Id,GetUD1Ac).MemberPk.MemberID
api.LogMessage(vTgtActID) 

Outcome is : -1

    MarcusHAnswer
    Expert
    May 16, 2023 9:01 AM UTC

    I think the problem is that you have added .MemberPk. This works for me:

    api.Members.GetMember(DimType.Account.Id, "HEADCOUNT").MemberId

     

    View in thread

    4 replies

    Employee - Advisor
    HenningEmployee - Advisor
    Employee - Advisor
    May 16, 2023 8:44 AM UTC

    Hi, what is the member name when you log "GetUD1Ac"? Does that match 100% with the member of which you intend to retrieve the ID? It seems likely that the string returned to GetUD1Ac may be a little inaccurate and therefor cannot be found in the dimension.

    BCGAuthor
    Newcomer
    May 16, 2023 8:53 AM UTC

    Acc value.png

    yes account GetUD1Ac value is correct. matching with log file

    MarcusHAnswer
    Expert
    May 16, 2023 9:01 AM UTC

    I think the problem is that you have added .MemberPk. This works for me:

    api.Members.GetMember(DimType.Account.Id, "HEADCOUNT").MemberId

     

      ChristianW
      Employee - Advisor
      ChristianWEmployee - Advisor
      Employee - Advisor
      May 16, 2023 9:27 AM UTC

      Hi BCG

      Markus is right, your MemberPk is false, you can access the MemberId directly from the Member object.

      But if you don't need the object, you can even access the id directly by using the following:

      api.Members.GetMemberId(DimType.Account.Id, "HEADCOUNT")

      Cheers

      Christian

        Terms & ConditionsAccessibility statement