Skip to main content
March 25, 2026
Question

CVR and GetDataCell Issue in cube views

  • March 25, 2026
  • 1 reply
  • 0 views

Hello, 

I currently have a cube where I am having an issue calculating variances. 

The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12). 

When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell.

I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?

1 reply

April 17, 2026

I have not used it so much - but try playing with this



Override Complex Calculations