Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

WF Time in cube view

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

Cube View
  • johnal67's avatar
    johnal67
    3 years ago

    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

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    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's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Alona Edwards

    Hi Dean,

    I use T#WFPrior12 and it works great.

    Cheers,
    Alona

    • johnal67's avatar
      johnal67
      Contributor
      3 years ago

      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