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...
Forum Discussion
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.
Hi Kit - I'm a bit confused with what you're specifically asking for, but you need the pipes symbol to accomplish it, if you are using the substitution variable of CVYear.
T#|CVYear|.Months would be the correct syntax to get all months in the Cube View Year. To get the prior year's months, try T#PeriodPrior1(|CVYear|).Months.
I'm not sure what this cube view is being used for, but I typically like to allow the time period to be selectable for the end user (unless it's forms related where I typically use T#WF). If you want to make it more dynamic, throw in a parameter, such as |!ParamMonth!| in place of |CVYear|
Thank you very much for the reply. I'm trying to get to a CV that would display 2 columns of data, Current Year and Prior Year for each of the 12 periods of a year.
On rows, I am just displaying the CY and Months.
I thought I could then override the row for prior year with something like this:
I've not been able to get that to display though. I have seen in most examples folks are doing similar things by displaying the periods in columns vs row, but I have users use to seeing the periods in rows, so was trying to replicate that. Any thoughts are greatly appreciated.