We have 8 sibling Import workflows under one parent(Base Input Type Parent). We have one entity that's being used to load data in all 8 import workflows. Because we have good volume of data and multiple users loading the data to each workflow, whenever someone try to load the file through any workflow it is processing Load Cube for all remaining workflows as well and this process taking long time. It seems to be expected behavior of workflow design but Is there any recommendations that I can try to reduce the processing time ? Any suggestions would be much appreciated.
If you move it to a separate workflow then that will remove all the data from other workflows. Channels will help in some way. However if you are touching the level 3 data unit then you don't have much options. It could reduce the load timings. However, that is the way OS works.