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

ssmith-nova's avatar
ssmith-nova
Contributor
1 year ago
Solved

Execute a Workflow multiple times with different periods from a BR

I am trying to automate a yearly load of data from a business rule.  I want the rule to loop through a set of periods and run a specific workflow for that period.  The workflow uses a connector rule ...
Data Integration
Workflow
  • sameburn's avatar
    sameburn
    1 year ago

    Hi ssmith-nova 

    If you derive the WorkflowUnitClusterPk from the Transformer api in the connector rule (rather than deriving this from SessionInfo), this will enable you to control, the WFProfile, Scenario and Time in your logic, as desired

    Hope this helps

    Sam

ssmith-nova's avatar
ssmith-nova
Contributor
1 year ago

Hi Sam,

Thank you for talking the time to reply to these questions.

I am trying to load multiple time periods at once.  The WF that I am running is a direct connect so the file I am creating is empty. 

I have two BRs, one is connector BR and one is an Extender BR.  In the Extender BR I am able to control the times that I want to run.  Typically, I would create a file and run the execute function.  Now I am trying to load six weeks of data (2025W1 - 2025W6).  I was trying to create six files, one for each week and then run the execute batch once. But the execute requires a time.  Is what I am trying to do not possible?

It is in the Connector BR that I was having issue with the period.  But you solved that by telling me to get the time from the Transformer.  Now my issue is that the WF has a calculation attached to it.  It's when it gets into the calc that I need to get the time.  However, I think I resolved my issue by using api.Pov.Time.Name.  I am still testing.  

Thanks again for your time,

Scott