Variables

Forum|Forum|2 years ago
December 13, 2023
2 replies
0 views

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 the next one? Does anyone know how to pull that data? So, if the CV is 2022 this variable will give the following year 2023, if I need 2024 and 2025 and so on. How do you expand on this variable?

Cube View

Best answer by RobbSalzmann

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.

RobbSalzmannAnswer

Legend

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.

M

mbahenaAuthor

Newcomer

Awesome, thanks for the feedback. Would you have an example for an XFBR function? I never used it before. Thanks in advance, your help is greatly appreciate it.

J

JackLacava

OneStream Employee

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.

M

mbahenaAuthor

Newcomer

Thank you for your time and the additional information. I will look into it, greatly appreciate it!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded