Forum Discussion

DamarisE's avatar
DamarisE
New Contributor II
4 years ago

Prior Year, YTD Cube View Columns

Hi All, I am creating a cube view with a 'Current Year' column and a 'Prior Year' column based on the POV (this company has an August close fiscal year).  These columns work if I am viewing full ye...
Cube View
aricgresko's avatar
aricgresko
Contributor III
4 years ago

Try this setup below if you want to make the report more dynamic for the users in terms of selecting the period and selecting the view dimension, unless your report requires it to be run based on user POV.

Note: |!ParamMonth!| is my parameter to select the month for the first column.

          |!ParamView!| is my parameter to let the user select Periodic, MTD, QTD, or YTD. 

 

 

 

 

Kit_Tyrrell's avatar
Kit_Tyrrell
New Contributor II
3 years ago

Hi, I'm new to Onestream and I am trying to do something similar, but in Rows I'd like to display all the periods of a given selected year and then all the periods of the prior year.  I've been unable to get this to work.   Columns   Year1, Year2.   Row1 T#CVYear.Months.   Any thoughts or suggestions would be appreciated.