Forum Discussion

SaurinPatel's avatar
SaurinPatel
New Contributor III
3 years ago
Solved

Parallel Imports

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 B...
Admin
  • scottr's avatar
    scottr
    3 years ago

    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.

scottr's avatar
scottr
New Contributor III
3 years ago

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's avatar
SaurinPatel
New Contributor III
3 years ago

Thanks a lot.