02-16-2023
12:34 PM
- last edited on
05-02-2023
10:36 AM
by
JackLacava
Hello OS experts,
I have BR that load P&L bucket and one BR that loads my BS bucket. I have DM sequence which load P&L,BS and then does consolidation etc. I want to know if I am able to write new BR or something I can do in DM to load P&L and BS data parallel to save time.
Let me know your thoughts and example code if you are doing it at your job.
Thanks
Saurin
*Migrated from onestream champions
Solved! Go to Solution.
02-16-2023 12:38 PM
yes, we load 12 parallel sequences for our customer cube load.
BRApi.Utilities.StartDataMgmtSequence(si, “Workflow_Sequence_1” )
…
BRApi.Utilities.StartDataMgmtSequence(si, “Workflow_Sequence_12”)
do
thread.sleep(60000) 'wait a minute
num_of_completed_steps = [get number of steps completed so far using task activity or a global counter]
loop while num_of_completed_steps < 12
I want to mention that our SQLServer takes a hit with alot of activity when this is running.
02-16-2023 12:38 PM
yes, we load 12 parallel sequences for our customer cube load.
BRApi.Utilities.StartDataMgmtSequence(si, “Workflow_Sequence_1” )
…
BRApi.Utilities.StartDataMgmtSequence(si, “Workflow_Sequence_12”)
do
thread.sleep(60000) 'wait a minute
num_of_completed_steps = [get number of steps completed so far using task activity or a global counter]
loop while num_of_completed_steps < 12
I want to mention that our SQLServer takes a hit with alot of activity when this is running.
02-16-2023 12:39 PM
Thanks a lot.