Forum Discussion

SaurinPatel's avatar
SaurinPatel
New Contributor III
2 years ago

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 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

Admin
  • scottr's avatar
    scottr
    2 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
    2 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.