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
Solved
Variables
Good Morning! Does anyone know how to build upon the set up variables in OneStream?
For Example: |CVYearNext| - This gives me the following year of the CV. What if I want the following Year and...
Hi mbahena,
For flexibility and reuse, I would use an XFBR for this requirement that takes two arguments, the current year, and an integer to add to that year, e.g. 2 for currentyear + 2 to get two years ahead, or -3 for currentYear + -3 to get third year prior.
I would recommend to explore the Member Filter Builder, there are plenty of examples on how to use built-in functions regarding time.
XFBRs give the ultimate flexibility when all these built-ins fall short, but the best option is always to reach for prebuilt functionality if available - it's easier and requires less maintenance than any custom code-based solution.
JackLacava
OneStream Employee
OneStream EmployeeI would recommend to explore the Member Filter Builder, there are plenty of examples on how to use built-in functions regarding time.
XFBRs give the ultimate flexibility when all these built-ins fall short, but the best option is always to reach for prebuilt functionality if available - it's easier and requires less maintenance than any custom code-based solution.
Thank you for your time and the additional information. I will look into it, greatly appreciate it!