Forum Discussion
Solved
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 c...
In your example, the Scenario name determines "current year". Your XFBR idea will work for that. But what if your scenario name doesn't contain an indicator of "current year"? You can anchor on WF Time, Global POV Time or POV Time.
Will the job be scheduled? If so, they system won't have a POV Time or WF Time so you can't use those. If the admin isn't diligent about updating the Global POV, then the extract won't contain the data you're expecting.
Will the job be triggered by a user from a dashboard? If so, you can pass that parameter into the step's Time Filter.
Once you determine the logic for what determines "current year", you have options to make the job dynamic.
sameburn
OneStream Employee
OneStream EmployeeIf you haven't already, you may want to consider adding Range criteria to your Budget scenario setup e.g.
- Range: To define a custom range that is displayed as a one-time period including the start and end time, such as 2023M12-2024M11. As data loads, each period displays this range.
- Workflow Time, Workflow Start Time, and Workflow End Time become selectable when Range is chosen. Click the ellipsis to choose a time for each. Year or year and month can be defined.
If this is the case, there are some BRApi's to help you retrieve these variables and derive the time range that is applicable for the Scenario selected
Hope this helps
Thank you for your suggestion. This would be ideal if I only had to define the time filter, but the issue is scenario also has to be dynamically selected which I forgot to mention in my question.
