amritp02
3 days agoNew Contributor II
Dynamic Time Filter in Data Management Export Step
I'm building a Data Management step to export data, and I need to set the time filter dynamically.
For example, if the scenario is Budget_Final_FY26, the export should include 5 years of data: the current year, plus current year +1 through current year +4.
The challenge is that I don’t see a way to directly use “current year” in the time filter. My idea is to substitute the time filter with an XFBR string that pulls the current year and applies it dynamically.
Has anyone implemented something similar, or is there a recommended approach for handling this?