Number of periods that can be validated at once
Hi, how many periods can be loaded and validated at once? I have the need to load 360 periods, but I seem to be getting timed out. thanks, Greg
Forum Discussion
Hi Greg, I am not aware of an exact technical limit per se, it depends on the amount of data you are trying to load and the how. May I ask for some more details? How are you loading the data (Excel, workflow, batch load,...?)? How much data (e.g. row count per load file)? Are you using Direct Load to avoid possibly unnecessary validation steps?
I am loading via a .csv file through a matrix data source where the Time periods are in the columns. I have tried an Import, Validate, Load. I have also tried the Direct load. I have tried one row of data and it still got stuck on the validate. Transformations for Time are set up well past the periods we are loading. The Scenario range is also set up past the load periods. We are doing some testing and logging, but wanted to see if there were similar experiences or there is something to check in the configuration.
Just to make sure it is not that, are those set to True in your respective scenario types in the Application Properties?
Presumably only 'Allow Loads After Workflow View Year' is needed to be set to True.