The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Bella_Yu's avatar
Bella_Yu
New Contributor III
1 year ago

Retrieve member property in SQL

In Application tab > Dimensions > Entity Dimensions > Member Properties, I have something configured in Text 4 and Text 5  field in Vary By Scenario Type And Time section. The goal is to display thes...
dashboards
Reports
FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi Bella_Yu,

You should as much as possible use the api functions instead of querying OS application tables directly which is usually not recommended.

In this case you might want to look into using the following function:

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