Get stored value of Entity Relationship property

Question

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 Answer

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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded