02-03-2020 03:54 AM
Hopefully a simple one - is there a way to dynamically select the prior year comparable for a Cube view based upon the workflow.
Column 1 = T#WF
Column 2 = T#(WF-12 Periods) or T#(WFPRIORYEAR) if you see what I mean?
The WF "snippets" in the Member filter Builder, Time functions does not seem to cover this.
Thanks in advance,
02-03-2020 05:55 AM
Check out the chapter in the Design and Reference Guide (the ? button within the OneStream Windows App or via the MarketPlace under Software) on "Time Functions and General References." You will see how to do all of this and more via using the |WFTime| substitution variable and the "MF" functions for relative time. There are also videos on this in OneStream Academy.
02-04-2020 05:35 AM
I use T#WFPrior12 and it works great.
06-29-2022 04:22 PM - edited 06-29-2022 05:19 PM
Am I missing something easy with how to refer to the Workflow prior "year end" regardless of what month is current? eg. (2022M5 compared to 2021M12, 2022M6 compared to 2021M12, etc). Updated: solved my problem with T#YearPrior1(|WFYear|)M12
08-31-2022 11:13 AM
Thank you for this!