Obtain entities in a BR for comparison

[Marco]

Hi Everyone.

What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get in a BR the value of an intersection, as if it were in excel.

Example the childrens of this.

[FredLucas]

Hi @Marco,

In order to get the base members of a specific member you can use the function below:

objList = api.Members.GetBaseMembers(dimPk, memberId, dimDisplayOptions)

I'm not sure I understood your question but if what you want is to do a check to see if the entity passed on the DataManagement is a base member of that specific parent entity then you could do something like this:

Dim hardcodedParentEntityName = "GroupA"
Dim hardcodedParentEntityID As Integer = api.Members.GetMemberId(dimTypeId.Entity, hardcodedParentEntityName)
Dim entityDimPK As DimPK = api.Pov.EntityDim.DimPk
						
Dim isValidEntity As Boolean = api.Members.IsBase(entityDimPK, hardcodedParentEntityID, api.Pov.Entity.MemberId)
						
If isValidEntity Then
  '...
End If

With regards to getting the value of a specific intersection you can use the following:

'Ensure you have the full POV defined here - For DU dimensions if no members are specific it will use the ones defined by the DataManagement
Dim cellAmount As Decimal = api.Data.GetDataCell("A#ABC:U1#A:U2#B.....").CellAmount