Forum Discussion
Solved
Dynamic DataSource Load
Hello,
I was wondering if there's a way to dynamically load a flat file once per year for a specific month. We load data yearly for our CapEx Budget and was wondering if you can assign a static val...
Set it to a Complex expression:
Return BRApi.Finance.Time.GetNameFromId(si, api.WorkflowUnitPk.TimeKey) & "M1"For performance reasons you might want to stash it into a global variable.
There might be faster ways to get the year, you might want to experiment with what is available in the api object.
Data Type = Current DataKey Time
That will use whatever your workflow time period is.
I tried that and it didn't work. We don't have any periods, it's just 1 full year workflow
- JackLacava
OneStream Employee
Set it to a Complex expression:
Return BRApi.Finance.Time.GetNameFromId(si, api.WorkflowUnitPk.TimeKey) & "M1"For performance reasons you might want to stash it into a global variable.
There might be faster ways to get the year, you might want to experiment with what is available in the api object.
Thanks for the help JackLacava! Appreciate it!