Parallel Imports

[SaurinPatel]

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

[scottr · Accepted solution]

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.

[SaurinPatel]

Thanks a lot.