02-15-2022 01:49 PM - last edited on 05-24-2023 11:56 AM by JackLacava
Hi All,
I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on.
I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated.
Thank you,
Mustafa
Solved! Go to Solution.
02-15-2022 05:23 PM
Probably lots of ways to build this, and it will vary based on you need (moving periods vs static periods). A few potential solutions for static periods:
T#YearPrior1(|CVTime|)H2.Months
T#PovPriorYearM6.AllNextInYearInclusive
The documentation has good coverage on this area: Platform Guides > Design and Reference > Cube > Time Functions and Workflow References
02-15-2022 02:39 PM
Hi - Try the using this as your column member filter: T#Year(|CVTime|)PeriodPrior5(|CVTime|), adjusting the number after prior period to the appropriate number of months prior
02-15-2022 04:18 PM - edited 02-15-2022 04:18 PM
02-15-2022 04:31 PM
Instead of |CVTime| try your |WFTime| as I'm guessing your Cube View POV is set to 2016 while WF POV is set to 2021
02-15-2022 02:41 PM
Also, for a total column X number of periods back, take a look at the ViewXXMonthTotal, like in example below
"Trailing T#WF:V#Trailing12MonthTotal:Name("LTM")
02-15-2022 05:23 PM
Probably lots of ways to build this, and it will vary based on you need (moving periods vs static periods). A few potential solutions for static periods:
T#YearPrior1(|CVTime|)H2.Months
T#PovPriorYearM6.AllNextInYearInclusive
The documentation has good coverage on this area: Platform Guides > Design and Reference > Cube > Time Functions and Workflow References
02-15-2022 05:32 PM
Thank you @db_pdx
T#YearPrior1(|CVTime|)H2.Months worked!! I just needed to replace CVTime with my own parameter.
Will check it out. Appreciate it.
02-22-2022 11:19 AM
How would you do this if you wanted the month prior to that half year? For example I want to see december 2021 for the first 6 months in 2022, but in the second 6 months I want to see June?
Thanks!
02-22-2022 11:34 AM
So, you want to see HalfYear1 and HalfYear2 for prior years?
Using the solution from above. Try adding "HalfYears" variable.
T#YearPrior1(|CVTime|)HalfYears.Months
02-22-2022 11:40 AM
Not quite, I'd like the Dec 2021 I have here to dynamically either show December or June based on what part of the half year they are in. I'm using T#Global.MonthsInHalfYear for the columns after the highlighted. Thanks!!
02-22-2022 05:12 PM
Hi paulacrisp: assuming your GlobalTime is an individual month, this should work:
T#FirstPeriodInHalfYearPrior1(|GlobalTime|)