Forum Discussion

Nirod95's avatar
Nirod95
New Contributor II
4 days ago

Multi year worflow load

Is it possible to have a Scenario Type with a 5 year input frequency?

I need to be able to load 5 years at once instead of having to change the wf year 5 times.

is it possible?

  • In terms of a workflow the least granular input frequency is Yearly. If you don't want the hassle of loading each year in the workflow then you can have a number of options.

    Use a Matrix data source load with the time period loaded to driven from the amount columns. 5 years of data can be loaded from one workflow. Similarly you could set up an Excel template load to load 5 years in one go

    Set up a batch load process which would automatically process 5 years of data if the data was in 5 separate files