Forum Discussion

MarcusH's avatar
MarcusH
Contributor III
2 years ago

Get stored value of Entity Relationship property

I am trying to get a stored value in Text1 from an Entity relationship:

This is the code that at least does not give me an error when it executes but it does not return the Text1 value.

Dim myScenarioID As Integer = brapi.Finance.Members.GetMemberId(si, DimType.Scenario.Id, "Actual")
Dim myScenarioType As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si, myScenarioID)
Dim myTimeID As Integer = BRApi.Finance.Time.GetIdFromName(si, "2021M6")
Dim myEntityID As Integer = BRApi.Finance.Members.GetMemberId(si, DimType.Entity.Id, POVEntity)
Dim myParentID As Integer = BRApi.Finance.Members.GetMemberId(si, DimType.Entity.Id, POVParent)

' Get relationship
Dim relationship As Relationship = BRApi.Finance.members.ReadRelationshipNoCache(si, DimType.Entity.Id, myEntityID, myParentID)
' Get the properties
Dim memProperties As New VaryingMemberProperties( DimType.Entity.Id, myEntityID, myParentID )
' Get the stored value
Dim Text1Value As String = memProperties.GetEntityRelationshipProperties().Text1.GetStoredValue(myScenarioType.id, myTimeID)

Any help much appreciated.

Finance
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    Hey Marcus, 
    There is a native easier function to do that :

    Dim sValue As String = BRApi.Finance.Entity.RelationshipText(si, _
    entityId, parentId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)

sValue = BRApi.Finance.Entity.RelationshipText(si, 0, -2, 900100, 0, 2021009000)

    But to be honest, I tried it on my side without success. No idea why. It seems pretty straighforward but no success!

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    Hey Marcus, 
    There is a native easier function to do that :

    Dim sValue As String = BRApi.Finance.Entity.RelationshipText(si, _
    entityId, parentId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)

sValue = BRApi.Finance.Entity.RelationshipText(si, 0, -2, 900100, 0, 2021009000)

    But to be honest, I tried it on my side without success. No idea why. It seems pretty straighforward but no success!

    • MarcusH's avatar
      MarcusH
      Contributor III
      2 years ago

      It works for me - I think the problem with your code is the 4th parameter - textPropertyIndex - I think that should not be 0.

      Thank you. I really appreciate that you have taken the time to sort out the problem.