The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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

2 Replies

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