Running Validate and Load Steps for Multiple Years
Hi everyone, We are uploading portions of our budgets in Excel templates across multiple years. The data is imported across all the years in one shot, but the validate and load steps need to be run year by year if imported through the workflows we have set up. Does anyone know if there is a way to execute the validate and load steps across multiple years through a rule? I know we can use the batch harvest folders, but we're hoping to keep the workflow steps as close to those used in other processes as possible. Thanks, James
Is there guidance on the setting for the number of parallel executions for Harvest Batch Loads?
When using the BRAPi.Utilities.ExecuteFileHarvestBatchParallel function in an Extender BR, does anyone have any guidance and/or opinions on the proper setting of the parallelBatchCount parameter? My understanding has always been to set it to a maximum of the number of CPUs - 1 , available for the server performing data management or batch load processing.
Assistance Needed: Updating "Profile Active" Property via Extender Rule
Dear Team, I am currently working on updating the "Profile Active" property for a specific scenario type within a workflow profile. I am trying to implement this change using the below code snippet, but am not seeing the desired result: code snippet: brapi.Workflow.Metadata.GetProfile(si, "Parent Profile.Profile Name").SetAttributeValue(ScenarioType.Control.Id, 1300, Boolean.TrueString) Though I am aware that this update can be performed manually by accessing individual workflow profiles or using the grid view, my requirement is to execute this task through an extender rule. I've identified that the attribute index for "Profile Active" is 1300 and the value to be updated is of an object type. I suspect there may be an issue with the way I'm passing the new value in the code. I would appreciate any guidance or insight on how to correctly update this property using the extender rule. Your assistance is greatly appreciated. Thanks
Setting Workflow via SmartLink
Hi guys, bit of an odd one here. Our client is looking to leverage SmartLinks once their 8.5 upgrade is complete. We are doing testing in their Development environment and have the SmartLinks up and running (mostly) as expected. Our SmartLink navigates the user to a specific dashboard, but the dashboard is WF driven. On top of that, when opening OS in the Web, it defaults the WF to the WF the user was most recently in. I know SmartLinks is a new feature, but was wondering if anyone had any intel on how far the code can go. We prepopulate parameters with the generated link, can Workflows (Profile, Scenario, Year) be set the same way? It doesn't seem like it. Not sure how I would go about this issue going forward, however. Thanks
Validation Error: No security access to data cell being cleared
Hi Team, We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step: All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears. Strange thing is: they have uploaded data on this intersection before in previous Forecast Scenarios without errors Security has not changed for either the application, user, workflow profile, entity etc. these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence. Application Security: ModifyData is set to Everyone One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security. I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step. Anyone that can help me a little bit more in understanding the error or knows what could cause this? Thanks in advance!Make document attachment required on journal
Hi Everyone, Our business team would like to make it mandatory to attach a document to every journal entry. I know this can be done via a confirmation rule. However, one of our business partners googled this and AI returned the information in the screenshot below so they are questioning why we can't enable the setting referenced. We can't find this in any of the OneStream documentation nor see it when creating new workflow forms or journal templates. Is anyone familiar with this setting?
