Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago
Solved

How to grab Prior 6 months in CV

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 memb...
Cube View
  • db_pdx's avatar
    db_pdx
    3 years ago

    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

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

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

psc's avatar
psc
New Contributor III
3 years ago

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!!

 

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    3 years ago

    Hi paulacrisp: assuming your GlobalTime is an individual month, this should work:

    T#FirstPeriodInHalfYearPrior1(|GlobalTime|)