The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sophie's avatar
Sophie
New Contributor
3 years ago

Custom Member Frequency filter for all previous periods

Hi All, We'd like to have a Form Template available only until 2022M9. To do so, we've entered the following parameters in the member Frequency filter of the Form Template: Is it possible to ...
Forms
Sweez's avatar
Sweez
Contributor
3 years ago

Sophie, the only thing I can think of, assuming 2022M9 is not a work flow time (T#WFTime) or Global Time (T#Global), is something like this.  However, I am not sure its any easer to populate what you proposed above.  

T#2022M9.AllPriorinYear, T#YearPrior1(2022).Months,, T#YearPrior2(2022).Months, T#YearPrior3(2022).Months, T#YearPrior4(2022).Months, T#YearPrior5(2022).Months, T#YearPrior6(2022).Months, T#YearPrior7(2022).Months

  • Sophie's avatar
    Sophie
    New Contributor
    3 years ago

    Sweez , Thanks for the suggestion!

    That works too.

    We can also use T#2022M3.AllPriorInYear, T#2022.Prior1.Base, T#2022.Prior2.Base, T#2022.Prior3.Base, T#2022.Prior4.Base, T#2022.Prior5.Base, T#2022.Prior6.Base, T#2022.Prior7.Base. 

    All of this works. My only concern is that we are having a long list of hard listed elements. Maybe there is an option where we can use a BRString, or a Parameter, or something comparable?

    Thanks in advance!