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
Concatenate results of two member filters
How do I concatenate 2 member filters?
Something like this:
No need for "+Month".
T#|!Param_YearSelect!||!MonthSelect!|
If you need to construct 2024M2 and they are separate parameters, just make sure your month parameter is expressed in M1 to M12 terms.
So if you use a delimited list, you can set description to be Jan to Dec but returned value as M1 to M12.
So, it's not possible to concatenate 2 functions?
The way you propose, I would have to have 2 buttons for time.
Based on your syntax, are you trying to essentially get the prior year of the same month?
E.g., |!Jumia_Conso_Act!| = 2024M4
Desired result = 2023M4
If so, you can try T#PeriodPrior12(|!Jumia_Conso_ACT!|)
There are numerous Time Functions available to achieve different dynamically derived time members so experiment with those?
