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

johnal67's avatar
johnal67
Contributor

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

WernerN's avatar
WernerN
Contributor
2 months ago

Thank you johnal67.  Worked like a charm.  Key was the |WFYear| in paranthesis that i could not figure out.