Forum Discussion

GaneshJ's avatar
GaneshJ
New Contributor II
4 months ago

Getting Dimension Info from Member Name

I am trying to get dimension info using a member name. I came across the function, Dim nValue As Integer = BRApi.Finance.Members.GetDimIdFromMemberId(si, dimTypeId, memberId), but it requires dimTypeId. Is it possible to get dimTypeId using member name

XFBR
  • Henning's avatar
    Henning
    4 months ago

    There may be ways in your code to make this dynamic, but just with the (metadata) member name alone, it will not be possible. As the same name may exist in different dimension types, the system would not know which one the rule is referring to.

  • Henning's avatar
    Henning
    Valued Contributor II
    4 months ago

    Hi, no, I do not think it is possible to get DimTypeId from a member name. That is because member names may be the same between different dimensions, e.g. None exists in every account-type dimension. With just the name, the system would not be able to know which dimension to return.

    Is it not working for you to provide the DimTypeId like this in the formula (using account as an example)?

    DimTypeId.Account
    • GaneshJ's avatar
      GaneshJ
      New Contributor II
      4 months ago

      Hi, "DimTypeId.Account" does work but we thought of keeping it as dynamic. 

      • Henning's avatar
        Henning
        Valued Contributor II
        4 months ago

        There may be ways in your code to make this dynamic, but just with the (metadata) member name alone, it will not be possible. As the same name may exist in different dimension types, the system would not know which one the rule is referring to.