Forum Discussion

ZAH's avatar
ZAH
New Contributor
3 years ago

Cube View Comments

Hello All,  I have a cube view in which i am using on the Row Level a GetDataCell Function, example GetDataCell(Account1+ Account2): Name (Trade). on the column level i have a Comment using the V#An...
Forms
TonyToniTone's avatar
TonyToniTone
Icon for OneStream Employee rankOneStream Employee
3 years ago

Is there a specific reason why you are using a GetDataCell in the Row level vs. creating a Dynamic Calc Account member to use in the Row level?  If you create a Dynamic Calc Account, you could set the Account Type to Dynamic Calc and Formula Type to DynamicCalcTextInput to allow commentary.  Write the GetDataCell formula as Return api.Data.GetDataCell("A#Account1 + A#Account2")

 

 

 

 

 

  • ZAH's avatar
    ZAH
    New Contributor
    3 years ago

    Hello Toni, 

    I am using a Row Template Cube , the purpose of the cube is for Analytical reporting whereby i just want the users to input some comments over a Caption for Combined Accounts . As if i am calculating a total and asking the user to explain the variance between two periods. Thats why i just wanted to be in the CV . moreover i have multiple Merged Captions  in the report as well .