Forum Discussion

WillVitale's avatar
WillVitale
Contributor
11 months ago

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...
Data Sources
Import
  • JackLacava's avatar
    JackLacava
    11 months ago

    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.

     

WillVitale's avatar
WillVitale
Contributor

I tried that and it didn't work. We don't have any periods, it's just 1 full year workflow

 

JackLacava's avatar
JackLacava
Honored Contributor
11 months ago

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.

 

  • WillVitale's avatar
    WillVitale
    Contributor
    11 months ago

    Thanks for the help JackLacava! Appreciate it!