Skip to main content
M
MMclean
Member
November 3, 2021
Solved

Intersection of cube view calculated rows and columns

  • November 3, 2021
  • 2 replies
  • 0 views

Hi,

 

When creating a simple cube view using both calculated rows and columns, the intersection of these two formulas doesn't display correctly. Is there a way around this?

 

See attached photo where Variance and Variance % columns both show the value of the first cell instead of the difference and difference percentage as they do in the other rows.

    Best answer by ChristianW

    Hi

    There is a calc order within cubeviews, columns will be calculated first and rows will be calculates second. I assume, that this is the problem. The good thing: RowOverrides will be calculate third and ColumnOverides last.

    I assume, if you move the calculation to the RowOverrides section of the column, it will work.

    Keep us informed, if it solved the problem.

    Cheers

    2 replies

    C
    OneStream Employee
    ChristianWOneStream EmployeeAnswer
    OneStream Employee
    November 4, 2021

    Hi

    There is a calc order within cubeviews, columns will be calculated first and rows will be calculates second. I assume, that this is the problem. The good thing: RowOverrides will be calculate third and ColumnOverides last.

    I assume, if you move the calculation to the RowOverrides section of the column, it will work.

    Keep us informed, if it solved the problem.

    Cheers

      A
      ajslack
      Newcomer
      November 4, 2021

      Here's a slide that walks through the order. 

       

      ajslack_1-1636056304274.png

       

       

        Terms & ConditionsAccessibility statement