Workflow and Data Integration

I have DEV and PROD OS environments. Is it possible to export the Gateway Configuration details from both OS environments and configure in one single Local Gateway Server? Or Do I need dedicated Local Gateway server for each OS environment?

Hello OneStream Experts, I was wondering if it is possible to set a value or retrieve a value (using XFGetValue) from user input for the "options" in the Data Export of a Data Management job while developing an Extensibility Rule.The goal is to give end users control over Data Exports without granting them access to the Application tab.Below is the code I developed to execute the Data Management sequence. I noticed there are a list of options that can be leveraged; however, I have not been able to set any values for these options. Any help or suggestions would be greatly appreciated.Thanks! 

I have drilled down to the bottom of both Origin and UD6 dimension which shows the data was loaded by corp accounting team.  However, i cannot view Audit history for Forms - it continues to show as grey'd out.   Does anyone know how to enable the audit history?  thank you.  

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

Hi Team, WhatIF_R&O_Adj is a Workflow Channel, and it is assigned under "Financial_WeeklyProcess" - "Base_Input Profile" (Refer the 2nd screen shot). when we are trying to unlock the channel. getting pop up like "'mnuWFChannelLockWhatif_R&O_Adj' is not a valid value for property 'Name'." and it is not listed under WF channel list(Please refer 3rd screen shot). Kindly help us to resolve the issue.     Thank you, Shiva Prasad.

Hi everyone, I have an issue in understanding how to implement multiple import steps within a workflow. My client will load data through a classing import step throughout all the months of the year. In addition to that, they asked to set up 3 additional import steps (P13, P14, P15) to be used in December that will serve as "adjustments" to the previous data loaded on the cube. At each import step, however, the data will be loaded in full (with eventual adjustments) and should overwrite the data loaded through previous import steps (and this is the reason why we don't use forms but we use multiple import steps). For example, when P13 is loaded, it should overwrite the data loaded through the Import step, and when P14 is loaded it should overwrite the data loaded through P13, and so on. The problem now is that since we are using a different workflow profile at each step, the system does not automatically overwrite the data loaded through the previous workflow profile, and therefore the

Hello dear community members, Background: We have had situations with month end workflow load validation errors which were fixed with UD1 mass upload. Few UD1 members ended up in Orphans, as the Parent did not exist yet in OneStream at the members mass upload step. The validation error disappeared and the workflow was complete. However, this created an Out of Balance and it was difficult to retrieve the issue.  Questions/potential solutions help required: Would it be possible for the month end Workflow load Validation error to ignore Orphan members and still get an error even when we create members and end up by mistake in Orphans. Is there a way to delete Orphan members with a BR? Is there a way to stop the Metadata builder xml file to create Orphans when a parent is missing from OneStream? Thank you in advance for any idea/suggestion/tip/hint.

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.

Hi all,I need to set up a complex expression to assign a specific value to the U6 dimension based on 2 source fields. Below part of the list of those source fields.The code I set up for the complex expression is the following:Dim fields As List(Of String) = api.Parser.DelimitedParsedValues() Brapi.ErrorLog.LogMessage(si, "Field count (List.Count): " & fields.Count) If fields.Count > 4 Then Dim loadedAccount As String = fields(4) Brapi.ErrorLog.LogMessage(si, "loadedAccount: '" & loadedAccount & "'") If Left(loadedAccount, 2) = "00" Then Return Right(loadedAccount, 8) End If Else Brapi.ErrorLog.LogMessage(si, "WARNING: only " & fields.Count & " fields; skipping Account logic") End IfEvery time I launch the loading process, however, it prints the WARNING message for all the rows, as if it didn't find any source field.Am I doing something wrong / is there an alternative way to retrieve the fields values that I am not considering?Th

How to configure the OneStream system to push the transaction and master data (dimensions) to Snowflake without manual intervention? I need step-by-step Info how to pull data from Snowflake into OneStream.

Hi everyone, I need to create a few journal templates so that they can be filled up in Excel and subsequently loaded into Onestream. I found online screenshots of some journal templates in Excel like the following one:but it's not clear to me how can I create it. Is there a way to export in Excel the already precompiled structure of a journal from Onestream? or do I need to create it manually in Excel?Any suggestion would help!

Hi everyone, I'm currently working on integrating OneStream with Dynamics 365 (D365) and would love to hear about your experiences. Specifically, I'm interested in knowing which connector you used for the integration. Did you opt for OData, Synapse Link, or another method? Any insights, tips, or recommendations would be greatly appreciated! Thanks in advance!

I have a requirement to load to the most recent unlocked period.  Using VB or C#, how do I check if a period is locked or unlocked?Thanks,Scott

Originally posted by Krishna SrinivasanHi - I am loading a simple CSV file into my Cube.   - Created Data Source - The Scenario & Time Dimension are Current Key. - Created Transformation rule. - Created Workflow profiles - Start the Import Porcess and got the below error   Summary: No valid DataKeys (Scenario / Time) found in data source.  Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source.   As anyone encountered this issue ? It is so strange even if I am not passing any values in the Data Source

I'm being asked to schedule an extract of the OneStream metadata.  I'm under the impression that this cannot be done using the Task Scheduler since an extract of metadata is not an option in Data Management.  Is this an accurate statement?  If this can be schedule, how so? Thanks!

Hi Everyone, We are trying to incorporate the status of the IC-Matching Report into the Confirmation rule. While reviewing discussions on the community board, I found the following object: brapi.DataQuality.Status.GetICMatchingStatusItems. However, I am having trouble getting it to work in a script. Could anyone share how they prevent users from confirming the workflow if the IC transactions do not match? Your insights would be greatly appreciated!    

I need to move some files around the various folders on our SFTP server and I am trying to do it via the Extender BR. Basically I need to move the files from the staging folder into various other folders based on the file names. The rule below compiles successfully. When executed, I get the exception on the second pass ("Chase" related) but no files are being moved anywhere. I am stumped at the moment and would appreciate any suggestions. Thank you in advance. Yan   Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try 'Set up SFTP connection session options Dim sessionOptions As New sessionOptions With sessionOptions .Protocol = Protocol.Sftp .HostName = "xxxxxxxxxx.xxxxx.com" .UserName = "XXXXXXX" .Password = "xxxXXxxxXXXXXx" .SshHostKeyFingerprint = "ssh-rsaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxpNuL5H42WiDJY=" End With 'Us

We have a form in our workflow for budgeting. Users have the option of interacting directly with the form or using a spreadsheet template we provided to update their values.  There are pre-seeded values in the cube. Users can then make adjustments to the amounts. When users are updating via the form, we are getting values replaced like we would want. However, when users interact with the form and update via our provided excel file, the amounts are getting appended to the original value. We can't seem to locate where this behavior is triggered on upload to form via Excel. Is there something in the VB we need to adjust, or is this a 'standard' behavior. We'd like to let our users simply replace the values.  Let me know if you need any add'l clarifications. Regards,DK

The query from SAP is currently returning the negative sign in the last position of a cell.ex.  20.56- when it should be -20.56Is there an SAP function I can add to the SAP connector solution that would place the - in the first position and how would I achieve this in OneStream?

Dear all,Do you have any idea how we can lock a workflow that has not any attached entity on it but should be based to a UD1?Thank you 

I am executing a Copy Data Management step which references a literal parameter (NOT in Default workspace) to get the scenario value. However, I am receiving an "Invalid Parameter" error when trying to use the parameter even though I confirmed the parameter is named correctly and has a value.  However, when I created the same parameter in the Default workspace, the Data Management step executed successfully.  In a Data Management step, is there a way to denote which workspace the parameter should be coming from? I tried something like: workspace_name.|!Scenario_parameter!| but no luck. Is there any documentation on this? 

We are looking to load data from a year-to-date (YTD) consolidated statement of subsidiaries. The statement is in matrix form, with accounts (both balance sheet and profit & loss) in rows and companies in columns. Each company has two sets of columns: one for financial results and one for eliminations. How can we set up the data source to read multiple companies' statements from one file? We would like to load eliminations to a separate origin (Elimination). How can we change the destination for the Elimination columns?  Also, how do we set up bypass row so that the load ignores headers and total rows? I noticed those rows can be identified by the Account column, where if the account is blank, then bypass. 

Hi, I need to build some tables in the application database. I am using a extensibility rule with a StringBuilder and the BRAPi.Database.ExecuteActionQuery command to do that. The "Create table" command is working fine. Eg:sqlScript.AppendLine("CREATE TABLE [PayrollMapping](")sqlScript.AppendLine("[Payroll]  varchar(255),")sqlScript.AppendLine("[Pay_Basis]  varchar(255),")sqlScript.AppendLine("[Salary_Annual_Factor]  Int")sqlScript.AppendLine(") On [PRIMARY]") But I cannot make the "Create table as select" command work. Eg this does not work (Error: Incorrect syntax near the keyword 'Select')sqlScript.AppendLine("CREATE TABLE [EBSRegister] As")sqlScript.AppendLine("Select [RegisterID], [FirstName], [LastName]")sqlScript.AppendLine("From XFW_PLP_Register") Is the "Create table as select" not a valid command for the OneStream BRAPi.Database or is there simply something wrong with the syntax above? Thank you

Hi everyone,I’m looking for some guidance or references regarding the Forms Event Handler. I would really appreciate it if anyone could help with the following:any  documentation or examples for using Forms Event Handlersany sample implementations or best practices shared by the communityHow to use Forms Event Handlers If there’s any downloadable content (like a sample/snippet), or even just some insights from your experience, that would be a great help.Thank You.

To integrate with SAP using RFC will I need to configure a data source on the SIC gateway or will I just need to add the appropriate DLL's to the referenced assemblies folder?