WF Time in cube view

[OSAdmin]

Originally posted by Dean Harper

Hi all,

Hopefully a simple one - is there a way to dynamically select the prior year comparable for a Cube view based upon the workflow.

So

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,

Dean

[OSAdmin]

Originally posted by Eric Davidson

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. 

[OSAdmin]

Originally posted by Alona Edwards

Hi Dean,

I use T#WFPrior12 and it works great.

Cheers,
Alona

[johnal67]

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

[DEReam13]

Thank you for this!