Workflow and Data Integration

We have some bunch of Step in our Sequence that we are calling it from Workflow Process step and this whole process is taking more than 2 hour around 2.5 hour . The process status is getting failed if it's running more than 2 hour but the Sequences is still running , as our process step showing failed we can't certify the Workflow . can you please help if there is way to fix this .

In OneStream how to eliminate intercompany process (POV, configuration)

  How ownership data can be uploaded or copied from one period to another in the OneStream App.

Hi, I know I can choose on which server to run a data management sequence but setting it in its Application Servers property, or leave the property blank to let OneStream determine on which server to run it. However, when launching a  data management sequence from a business rule, using the BRApi.Utilities.StartDataMgmtSequence() command for example, the Application Servers property seems to be ignored. Is this the expected behaviour? Is there any other way to force a data mgmt sequence to run on a specific server when called from a business rule? Thank you

How do i specify in a  data management task to extract the data to the cube\scenario/workflow step folder and not the user's folder under file share.    

Originally posted by Vignesh MohanHi, I am trying to import data from Snowflake using JDBC / ODBC connection. In the Snowflake side a view has been created with the correct data set for the import. The connectivity as such works as I tested the same through the Data Adapter in the Dashboards. I am able to retrieve data for the same query that I am using in the connector rule using this test method. The data structure type in the data source section in OneStream is setup as Matrix data as I need some of the column names to be mapped to the Accounts dimension members. When I run the data import from the workflow, I get the following error, 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. All dimensions are mapped appropriately in the transformation rules. I am also using few attributes to import

What is the difference between WorkflowUnitClusterPk vs WorkflowUnitPk? When would you use one over the other?   Thanks, Scott

Hi i now have access to Onestream Navigator and would like some recommendations of which courses to complete to get an understanding of how to extract data out of Onestream  Does anybody have any courses that were done that would be of help

How to convert a MT940 bank file to CSV readable format for data load

Hi all, how do you run an aggregation, i.e. calculate the "Aggregated" member of the consolidation dimension, without running a consolidation? In particular, would it be possible to setup the Process step of a workflow profile so that it runs an aggregation (as opposed to a consolidation/force consolidation)? Thank you

I have an IsOptional=True direct connect Import/Validate/Load Workflow channel.  I would like to be able to Complete this Workflow channel via the OS api without having to import/validate/load anything, the same as if someone selected the 'Complete Workflow' button just to the right of the 'Clear' button in OnePlace.  Actually, I have a number of such workflows, some are only required for M12 and others are placeholders for data that is being copied directly into the cube from other non-linked cubes. I can complete/revert the Workflow channel if it is set to Workspace using BRApi.Workflow.Status.SetWorkflowStatus().  And I can revert Import/Validate/Load workflows with the SetWorkflowStatus() too, but I do not appear to be able to complete the WF unless I'm at the last step or advance the steps with SetWorkflowStatus(). The BRApi.Import.Process.* functions will advance me through the Import/Validate/Load steps, but I cannot see how to do so without the functions imp

What is the Time Zone in Task Scheduler 'Start Date/Time'?  

Hi, I have a requirement to import a Cell Details CSV file into OS. My questions are as below: 1. Can we import a CSV file from Documents/Public/xyz folder to OneStream Cube? I tried it but it didn't worked. However, I was able to import the CSV from File Share folder. 2. To achieve above, I was trying to copy the CSV file from Documents/Public/xyz folder to File Share folder but I am getting an error "Part of the path cannot be found" (SRC Path: Documents/Public/xyz folder).   Error:   Here is the code to copy a CSV file from Documents/Public/xyz folder to File Share folder: If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Move_File_from_Public_to_FS_Folder") Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp( _ si,True, configsettings.fileShareRootFolder,si.AppToken.AppName) Dim DestinationPath As String = "Cell_Detail

Hey, So I am testing the Workflow Name "Central Import" since I recall it from Designing an application course. But I have a hard time understanding how to change status on the profiles after data have been loaded for the entity. This is my current setup: My regular "Import, Validate, Load" where I can load unassigned entities. Below is my "Central Import" Workflow step in another location with the assigned entity. And you can see that it is indication that data has been loaded through the "central" load step. However status is gray and wont change even if i certify central load step or the parent level.  Or am I configuring this in the wrong way maybe? 🙂   Thx in advance

New to OS and I have requirement to automate fx rates in OS. Is it possible? We have FX repository in Oracle so, thinking to pull from there but not sure how can we load to central FX repository.    

When loading data into OneStream, our longest workflow takes ~40 minutes to load. We would like to try to kick off the 5 direct connect loads within this workflow to start simultaneously instead of sequentially. Have any of you organized your loads similarly and do you have tips or recommendations please?

When we attach a file to a Reconciliation, where is the file stored and how is it stored?  It it stored in the application database as a BLOB or on the application server in the file system?  Is it encrypted?

  Hello, I have created a "Data Copy" "Data Management Step" which copies base level entity data from one scenario to another. I am copying import, forms, and journals.  When I run the step I am receiving the following error: "Error processing Data Management Step 'DM Step Name'. Error processing Data Management Step 'DM Step Name'. Journal 'Journal Name' contains line items for entity 'Entity Name' which is not currently being processed." I reviewed the source journal entry and ensured that it was posted and that the entity calculation status was "OK". This error is only occuring in one period as well works fine when I copy other periods. When I review the journals in both periods they are identifcal other than the amounts.  Has anyone else come across this before?  Thank you!

Hi Community,I was looking in SIC guide and over the community but I dont see find a simple question.- If we can have two SIC (Gateway Server) install into the same server that each will be point to different environment (e.g. one for Dev and one for Production different environment).Not sure if anyone has done that type of configuration or it might not be possible because of port conflicting?Thank you

Hi  I need to add two base member accounts in the member filter of a cube view. Would this be the correct syntax: A#Account1, A#Account2. Or do you need to add a plus sign between them? Regards  

As the subject line says I am trying to extract a Maintenance unit using a business rule.  We are on 8.1.0.  Below is the code I am using.  I have tried to use MetadataExtract.ExtractXML and XmlExtractContoller.ExtractXML, but I don't get what I am looking for.  It ends up dumping everything into the XML file. The name of the Maintenance Unit in this case is Integrations.  Can anyone see what I am doing wrong, or is there another Method I should be using?   ' Extract options Dim xmlOptions As New XmlExtractOptions ' extract all items xmlOptions.ExtractAllItems = False ' extract specified items Dim extractDict As New Dictionary(Of XmlExtractItemPk, Boolean) ' Groups are required to be added if extracting Cube Views extractDict.Add(New XmlExtractItemPk(XmlExtractItemType.DashboardMaintUnit,"Integrations"), True) 'extractDict.Add(New XmlExtractItemPk(XmlExtractItemType.BusinessRule,"XS_ExportAppTypes"), True) Dim xm As XmlExtractItemPk = New XmlExtract

Hi all  have you ever seen this error message? I am logged as administrator but when I try to import the journal from excel I receive this error message. "Security Access Error. Unable to create journal. Company X 2021M12_Investment Template Top_ACTUAL_TEST." Thanks for help, Marcello

Good Day  I would like to know what could I possible check to ensure that a green cell turns to white so users can input data. I have checked the Accounts dimension on the row as well as the override dimension and the allowed input has been set to true. Further to that I have checked the UD dimensions on that cell and those are set to true as well. I have checked on the cube view and the modify data is set to true as well. Is there some other place I could see to resolve the issue?   Regards Rehaan

Does anyone have example code they'd be willing to share here that allows the Intersection Error report to be attached and sent via email when errors are encountered during *automated* load processing?Our users are being notified that an error has been encountered, but they have to log into OS to look up what the error was (new unmapped account, etc.). It would be nice to provide the error detail as an attachment or in the body of the email.Also just curious how others in the community are notifying users that Load Errors have been encountered during automation, and providing the error detail to them?Any input is appreciated.Thanks!

Hi all,  We created a test account to load some test data into but we now would like to remove the account. How would I go about clearing the data from the account in order to delete the account? The data was inputted into the account using an XFSET function.   Thanks!