Skip to main content
S
SaurinPatel
February 16, 2023
Solved

Parallel Imports

  • February 16, 2023
  • 1 reply
  • 0 views

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

Best answer by scottr

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.

1 reply

S
scottrAnswer
February 16, 2023

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.

S
SaurinPatelAuthor
February 16, 2023

Thanks a lot.

Terms & ConditionsAccessibility statement