Newcomer

Prior Year, YTD Cube View Columns

Forum|Forum|3 years ago
August 18, 2022
2 replies
0 views

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 year over full year, but if I want to view Feb 2022 YTD vs Feb 2021 YTD, it does not work for the prior year. The values returned for 2021 only show the full year. Is there a way to dynamically pull 2021 YTD data based on POV?

Attached is a snapshot of what I currently have tried.

Any help would be greatly appreciated.

Thanks,

Damaris

Cube View

D

DamarisEAuthor

Newcomer

Hi everyone, My team and I figured this out. We ended up using: T#YearPrior1(|CVTime|)Period(|CVTime|) to pull current period prior year data. Curious as to why this is not in the design document, this is a standard reporting requirement.

Thanks,

Damaris

aricgresko

Veteran

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.