Skip to main content
A
Anonymous
February 3, 2020
Solved

WF Time in cube view

  • February 3, 2020
  • 2 replies
  • 0 views
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

Best answer by 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

2 replies

A
Anonymous
February 3, 2020
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. 

A
Anonymous
February 4, 2020
Originally posted by Alona Edwards

Hi Dean,

I use T#WFPrior12 and it works great.

Cheers,
Alona

J
johnal67Answer
Contributor
June 29, 2022

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

    D
    DEReam13
    Newcomer
    August 31, 2022

    Thank you for this!  

      Terms & ConditionsAccessibility statement