Skip to main content
G
grillin7
Newcomer
October 2, 2025
Solved

display a Textvalue in a Cube View loaded in an import

  • October 2, 2025
  • 1 reply
  • 0 views

I have configured a datasource where TextValue is taken from a column of a flat file to be loaded, the file loads well from the Import and I see the text for each loaded row, but I have not been able to display it in a CubeView, is this possible?

 

Best answer by sameburn

Hi grillin7​ 

This is called Relational Blending e.g see Design & Reference guide -> https://documentation.onestream.com/docs/Content/Design%20and%20Reference/Financial%20Model%20Guides/Relational%20Blending%20API.html?Highlight=GetStageBlendTextUsingCurrentPov

You can use either of these api methods (available from a Finance BR or Member formula) in a Dynamic Calc to return that text value e.g.

' GetStageBlendTextUsingCurrentPov
Dim sValue As String = api.Functions.GetStageBlendTextUsingCurrentPov(cacheLevel, cacheName, wfProfileName, fieldList, criteria, fieldToReturn, textOperation)
' GetStageBlendText
Dim sValue As String = api.Functions.GetStageBlendText(cubeName, entityName, scenarioName, timeName, accountName, cacheLevel, cacheName, wfProfileName, fieldList, criteria, fieldToReturn, textOperation)

Both methods are described in detail in the D&R link provided above.

Hope this helps

Sam

1 reply

S
OneStream Employee
sameburnOneStream EmployeeAnswer
OneStream Employee
October 5, 2025

Hi grillin7​ 

This is called Relational Blending e.g see Design & Reference guide -> https://documentation.onestream.com/docs/Content/Design%20and%20Reference/Financial%20Model%20Guides/Relational%20Blending%20API.html?Highlight=GetStageBlendTextUsingCurrentPov

You can use either of these api methods (available from a Finance BR or Member formula) in a Dynamic Calc to return that text value e.g.

' GetStageBlendTextUsingCurrentPov
Dim sValue As String = api.Functions.GetStageBlendTextUsingCurrentPov(cacheLevel, cacheName, wfProfileName, fieldList, criteria, fieldToReturn, textOperation)
' GetStageBlendText
Dim sValue As String = api.Functions.GetStageBlendText(cubeName, entityName, scenarioName, timeName, accountName, cacheLevel, cacheName, wfProfileName, fieldList, criteria, fieldToReturn, textOperation)

Both methods are described in detail in the D&R link provided above.

Hope this helps

Sam

Terms & ConditionsAccessibility statement