Forum Discussion

GaneshJ's avatar
GaneshJ
New Contributor II
1 year 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
Icon for OneStream Employee rankOneStream Employee
1 year 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
1 year ago

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