Forum Discussion

grillin7's avatar
grillin7
New Contributor II
2 months ago
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 to display it in a CubeView, is this possible?

 

Cube View
Dashboards
  • sameburn's avatar
    sameburn
    2 months 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

1 Reply

  • sameburn's avatar
    sameburn
    Icon for OneStream Employee rankOneStream Employee
    2 months 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