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
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 ...
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
sameburn
OneStream Employee
OneStream EmployeeIn this use case, you can control wf, Scenario and Time using the batch harvest file created. Instead of using Transformer api. This would be your control. Not sure where finance rules fit into this though
To your point here, if I have the scenario and time on the batch harvest files, when I run ExecuteFileHarvestBatch, does it ignore what I put for the scenario and time? Or is there a default at this level? On the file you can include C or G for time for the current period or global period. But I haven't seen anything for the ExecuteFileHarvestBatch command:
Function IBRApiUtilities.ExecuteFileHarvestBatch(si As Sessioninfo, currentScenarioName As String, currentTimeName As String, validateTransformation As Boolean, validateIntersections As Boolean, loadCube As Boolean, processCube As Boolean, confirm As Boolean, autoCertify As Boolean, throwOnError As Boolean) As WorkflowBatchFileCollection