Wondering if anyone can point me in the right direction here. I'm sure there is a way, it could be in procedure setup or it could be in BOARD server setup, i'm not sure, but keen to hear what suggestions others have.
Is there anyway to get BOARD to run multiple procedures concurrently?
At this client there are several users who a responsible for different entities within a group of companies. When they update their entity(s) budgets it requires a fairly lengthy procedure to be run to calculate and apportion quite a bit of data, and whilst this is being run it can delay other procedures from being run.
I am happy for the calculation of other entities/users budgets to have to wait whilst a budget procedure is running, that seems safest to me as they will be impacting the same cubes.
However what about procedures that use completely independent cubes? There are several screens which use dataviews with procedures to control user/screen selection. These procedures clear/set cubes to use for screen selection and so also get held up when a budget calculation procedure is being run. These are the ones I'm more interested in.
Is there anyway to get multiple procedures happening at once (without clustering) or is that not going to be possible in BOARD?