Get stored value of Entity Relationship property

[MarcusH]

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.

[NicolasArgente · Accepted solution]

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]

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.

[NicolasArgente]

Oh! You are correct - I did not spot that! Thanks @MarcusH  for the feedback. Appreciated.