Reporting
Questions about Cube Views and Reports
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! How to add a formula in a cubeview

I'm looking to add a formula that takes an account and subtracts the difference between two scenarios. So, something like this: GetDataCell(A#ProductionTCFacSTd:S#Target_FY24) - GetDataCell(A#ProductionTCFacSTd:S#Target_FY24_SC). Can you please help ...

bisenhart by New Contributor II
  • 581 Views
  • 1 replies
  • 0 kudos

Resolved! Variables

Good Morning! Does anyone know how to build upon the set up variables in OneStream? For Example: |CVYearNext| - This gives me the following year of the CV. What if I want the following Year and the next one? Does anyone know how to pull that data? So...

Time Variables.png
mbahena by New Contributor II
  • 904 Views
  • 4 replies
  • 0 kudos

Resolved! CubeView Member Expansion based on 'AllowInput=True'

Hi Team, I am trying to create an Input CubeView with an expansion based on whether the 'Allow Input' setting is set to True for our UD5 Dimension Members. To give a little bit of background, we are using the UD5 dimension for our Customer Codes. The...

Rianne_0-1702475329239.png
Rianne by New Contributor II
  • 591 Views
  • 1 replies
  • 0 kudos

How to calculate values of the same column in the Calculated Field

Good morning, I am writing to inquire about the correct formula for calculating the difference between two values in the same column in a Calculated Field of a Report Design. For example, if I wanted to calculate the difference between the values 121...

Fh1_2-1702459420590.png
Fh1 by New Contributor
  • 581 Views
  • 2 replies
  • 0 kudos

Resolved! Cube view rows suppression

Hi all, I'm struggling to understand how the setting "Use suppression settings on parent rows" in cube views works. I have this simple CV showing a list of accounts in the rows (1C205000 and descendants) and time in the columns: in the rows "Advanced...

fc_1-1702281081987.png fc_2-1702281197853.png
fc by New Contributor III
  • 854 Views
  • 3 replies
  • 0 kudos