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
Solved
display a Textvalue in a Cube View loaded in an import
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...
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
sameburn
OneStream Employee
OneStream EmployeeHi 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