OneStream Community

CAOK · 03-27-2023

My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calculated from the two first columns. Works fine except ...

CAOK · 05-11-2022

I have CV - rows with Accounts as Expansion 1 , and three Origin-member as Expansion 2. I'd like to have the Accounts as suppressed if zero ( no problem) but when I open the +-sign to see the Origin members for selected account I want all three (Form...

CAOK · 03-28-2023

Thanks! It works - not sure why though, is it that by setting it as an override I set the calc order in the CV so that these columns are calculated after the rows?

CAOK · 03-28-2023

OK, what would that column override look like? And in that case I suppose I could not combine column and row templates because I would have to hard-code the override?

CAOK · 03-28-2023

In theory yes, but I don't think it references the summed value - I have had problems with this before. The definitions are for column 3: GetDataCell(CVC(actual)-CVC(budget)):Name(Var mkr) and for column 4: GetDataCell(VariancePercent(CVC(actual), CV...

OneStream Community

User Statistics

User Activity

Cube-view: Calculate a column based on a calculated row

Cube view: Suppress if zero on Expansion 1 but show all on Expansion 2 when opened up with the +.

Re: Cube-view: Calculate a column based on a calculated row

Re: Cube-view: Calculate a column based on a calculated row

Re: Cube-view: Calculate a column based on a calculated row