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,
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.