Skip to main content
Z
ZAH
January 10, 2023

Cube View Comments

  • January 10, 2023
  • 3 replies
  • 0 views

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#Annotation:Name(Comments). however, on the GetDataCell the Comment is highlighted in Green. is there a way to be able to allow the user to write a comment on row that contains a GetDataCell function? 

3 replies

C
chul
January 10, 2023

You could use a row override for the column as you'll need to specify an account where the comment will be held. It's like a home address - if you're missing part of it (in your case, account), then OS doesn't know where it needs to store the comment (or data, for that matter).

Z
ZAHAuthor
January 13, 2023

I tried it, it doesn't work. the Cell for the Comment stays in Green. (Read Only)

D
Dan_Welcheck
July 3, 2025

Anyone figure out a solution to this?

When I try to do an override, it seems to tack the GetDataCell formula onto the end of the POV, so I'm guessing that is what's preventing it from offering up an editable cell for comments.  

Thanks in advance for anyone with some insight.

T
TonyToniTone
January 10, 2023

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")

 


TonyToniTone_0-1673364358150.png

 


TonyToniTone_2-1673365081407.png

 

 

 

Z
ZAHAuthor
January 10, 2023

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 .

N
NatHC
July 8, 2025

Hi Dan,

I haven´t found a solution, but if the cube view does not have a lot of columns, what I do is put a base level account in the row and in the column override put the getdatacell. I hope this workaround helps you.

D
Dan_Welcheck
July 17, 2025

Thank You NatHC, 

That works good enough for use to get some key intersections and will have to do for now.

Regards

Terms & ConditionsAccessibility statement