Nirod95
4 days agoNew Contributor II
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?
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