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 dimType...
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.

GaneshJ's avatar
GaneshJ
New Contributor II

Got it, Thank You!!

rhankey's avatar
rhankey
Contributor
4 months ago

You could cycle through each of the DimType's looking for the member name.  In many instances, that would narrow it down to a single DimType.  Worst case, you could at least prompt the user for a list of DimType's the member is actually in.  At the end of the day though, you are attempting to buck how OS is designed.  Member names have to be unique within a DimType, but it is perfectly acceptable to reuse member names across DimType's (eg None, Root, Top, Unassigned) 

  • GaneshJ's avatar
    GaneshJ
    New Contributor II
    4 months ago

    Thank You!!