Forum Discussion

grillin7's avatar
grillin7
New Contributor II
5 days ago

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...
Cube View
Dashboards
sameburn's avatar
sameburn
Contributor III
2 days ago

Hi grillin7​ 

This is called Relational Blending e.g see Design & Reference guide -> Relational Blending API

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