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

      • BoscoBear21's avatar
        BoscoBear21
        New Contributor
        2 years ago

        Thanks!  I can try that change.  In a planning app, I am trying to run in parallel (for the client) 7 years worth of clearing and copying data.   The current process that is in place does each one of the years back to back to back, etc.,  Takes a long time/  The End User, from a Dashboard, is prompted to select the Entity and To/From Scenarios to clear/copy