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

sandeepr's avatar
sandeepr
New Contributor II
2 years ago

Datamanagement sequence

Hi Everyone, I have requirement to run 4 data management steps in parallel, is there a way to run 4 data management steps same time?   Thanks in advance.    
Finance
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi Sandeep

I haven't tried to run data management steps in parallel before, but what you could try is to put each step in it's own sequence and then kick them all off at once using a business rule: 

 

BRApi.Utilities.StartDataMgmtSequence(si, "Sequence 1", Nothing)
BRApi.Utilities.StartDataMgmtSequence(si, "Sequence 2", Nothing)
BRApi.Utilities.StartDataMgmtSequence(si, "Sequence 3", Nothing)
BRApi.Utilities.StartDataMgmtSequence(si, "Sequence 4", Nothing)

 

This should start each of them in the background, so I think it will effectively run them in parallel.

Regards,

Mark

BoscoBear21's avatar
BoscoBear21
New Contributor
2 years ago

 

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    Hi Stephen

    In order to pass parameters to the sequence you need to create a Dictionary (Of String, String). See below:

    'Prepare Parameters
Dim params As New Dictionary(Of String, String)
params.Add("Paramter1Name", "Paramter1Value")
params.Add("Paramter2Name2", "Paramter2Value")

'Execute Sequence
BRApi.Utilities.StartDataMgmtSequence(si, "DataMgmtSequenceName", params)

     

    • MarkBird's avatar
      MarkBird
      Contributor III
      2 years ago

      Example using your code:

      'Prepare Parameters
Dim params As New Dictionary(Of String, String)
params.Add("FCSEntity", SelectSeedingEntity)

'Execute Sequence
BRApi.Utilities.StartDataMgmtSequence(si, "ClearTest1Prior", params)

       

       

    • BoscoBear21's avatar
      BoscoBear21
      New Contributor
      2 years ago

      Thank you Mark,  I implemented those changes and am a little closer to resolving the issue ... I am attaching a screenshot of my DM (with the prompts for E# and S#) as well as the BR coding and the error message.  Any help/thoughts is greatly appreciated!

       

       

       

      • MarkBird's avatar
        MarkBird
        Contributor III
        2 years ago

        First off, your parameter names are wrong, Try this:

        'Prepare Parameters
Dim params As New Dictionary(Of String, String)
params.Add("SelectSeedingEntity", SelectSeedingEntity)
params.Add("FromScenario", FromScenario)
params.Add("ToScenario", ToScenario)

'Execute Sequence
BRApi.Utilities.StartDataMgmtSequence(si, "ClearTest1Prior", params)

        But secondly, what are you trying to achieve? It looks to me like you have a Data Management Sequence that executes a custom calculate function that is just going to execute another Data Management Sequence?