Workflow and Data Integration

Hi All,This is probably an easy one, but I am stuck.I have a Dashboard dataset rule that used FDX to run a query.  It takes two input values. I have a data adapter that calls that BR and I can hardcode parameters in there to pass to the BR.  Now I am trying to call that Data Adapter using the REST API.  I am trying to pass parameters using CustomSubstVarsAsCommaSeparatedPairs.   How should I have the Data Adapter set up to accept these parameters.  For reference the hardcoded query looks like this:{_GetData}{GetDataSet}{ScenarioName=Actual, TimeName = 2024M3}What do I need to change "Actual" and "2024M3" to in order for it to use the values from the REST API call?Thanks,Scott

Hi everyone,  I’m trying to connect to the OneStream internal database so I can access the application data using DBeaver as my database manager. Has anyone successfully done this before? If so, could you share the steps or any tips to get it working?Thanks in advance for your help!

When I pull a flat file from an SFTP server, I have been parsing that file in VB .net into a Data Table and loading it that way.  Is this the best way to do this, or is there a way to make the Import read the file from the filesystem once it has been downloaded?  I feel like parsing a csv file using Split() is risky.Thanks,Scott

I´ve setup a process, confirm and certify workflow steps on the Base input workflow profile and I would like to setup automated run of this and email notifications for the confirmation results. Does anyone have an example of business rule for this? I expect it is different then the general one used for automating imports. 

Hello, I am trying to set up the Cube Data Manager solution from Open Place in my working production application. Currently it is all loaded up, but I need a little help figuring out how to add the environment to it containing the applications that I want to work with. Please see pictured below.   Thank you, Jeremy Morgan

Hi Community, Does anyone have experience with integration between OneStream and Microsoft Fabric? Please share your comments and a potential connect.  Thanks  Rajnish

I've read somewhere that there is a Postman collection for the Rest API.  I am just getting started with it and was hoping someone had one already set up. Thanks,Scott

...

Hi,I have installed the solution 'Application reports' in my application.I have added the report WF_ImportDetail_AccountMapping_RPTAR to my workflow by using a form template. When I click on the report in the workflow i am getting a pop-up screen for a parameter. The report should automatically use WF Profile, WF Scenaro en WF time. How do I set that up? John  

Hi Dears,Could anyone please provide me the practical steps to Integrate the MS SQL DB to OneStream.we are at presently testing with the data integration to learn the integration. Kindly provide the real time steps which can workOnestream - On-prem enviSQL DB - Local hostregards,BCG

Error Message:Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user.The statement has been terminated. (SQL Error Number -2146232060, -2, 0, 3621). The wait operation timed outThis happened after running Load and Transform for one of my import workflows. Any idea what's causing this? It stops at the PostFileArchives stage:

Originally posted by Krishna Srinivasan Hi - I have a requiremnt to flip a sign for a particular account in the transformation rule complex expression ? is there way to do it ?   Thanks Krishna

Has anybody been able to create a database connection to the QAD ledger system to import data to OneStream?  We are having a nasty time getting SQL to pull from it.

We're transitioning to TCPS - Port 2484 from TCP - Port 1521. I have no issues connecting via TCP, but have issues connecting via TCPS. Does OneStream support TCPS connectivity? Can't locate any documentation about this.

Hi All,Just curious if anyone has had success pulling data (SQL) from D365's Asset Ledger to get the continuity / movements for Fixed Asset accounts?  In other words, it would provide the Flow movements like Additions and Disposals for the Fixed Asset accounts to justify the change in the Balance Sheet account balance.Has anyone ever successfully done this, specifically using SQL from D365?Thx,Mike

Hi everyone, Just hoping for a few pointers in case others have come across this before... I have a "Group Overlay" workflow set-up specifically to post central adjustments at year-end (for tax purposes mostly). It works fine as it has a specific workflow channel assigned meaning that the group tax team can review numbers submitted by businesses after they have been completed and then overlay group adjustments without having to unlock/uncertify the indiviudal workflows. However, I want to be able to run confirmation rules within this group adjustment workflow. I haven't got this working, here are some of the things I've found. Has anyone else done something similar? If so I would welcome your ideas! - The adjustment workflow has no entities assigned to it, but it does have "Can load to unrelated entities" option ticked" to allow adjustments to any entity in the group - Because there are no assigned entities, the normal confirmation rule logic needs some tweaking I think as there are no

I'm building a Data Management step to export data, and I need to set the time filter dynamically.For example, if the scenario is Budget_Final_FY26, the export should include 5 years of data: the current year, plus current year +1 through current year +4.The challenge is that I don’t see a way to directly use “current year” in the time filter. My idea is to substitute the time filter with an XFBR string that pulls the current year and applies it dynamically.Has anyone implemented something similar, or is there a recommended approach for handling this?

We have several applications calling OneStream data adaptor via Rest API. Very frequently and randomly the connection fails with a 500 error. If we wait and retry the connection is successful. We have not been able to find the root cause.  We observed that when the Rest API has 2 entries in the Log Activity table in OneStream the connection is successful. The screen shot is from the Logon Activity table in OneStream. Every so often the connection fails with a HTTP 500 Error and we observed that only one the set is entered in the table. Have any of you encountered this type of issue.     

Hi Folks, We're just starting on a OneStream SaaS implementation to replace HFM. We're far from the stage of actively working on any data integrations yet but I'm already starting to think about how things will hang together and how data will potentially flow in the future state of things. Two of the downstream feeds that we currently receive in our HFM system are companies which are current users of OneStream SaaS. Just thinking at a very high level for now, does anyone know if there are any ways downstream systems could submit data to us without punching out to the internet e.g. using Azure Private Link service and staying within the Microsoft network (or some other networkey magic)? High level pretty picture :) Obviously we wouldn't be able to configure this ourselves as this is SaaS but I'm interested to hear if anyone else has any experience exploring this or anything similar with OneStream SaaS and if anything like this is even possible in the SaaS world. Regards Craig

Hi all,I have an Import, Validate, Load workflow that hasn't been used for a while. I'm trying to load in data and I'm getting invalid intersections at the validation stage with the following error message:"Data Cell is read-only because Parent Workflow Profile 'Workflow Name' has no active Input Profiles for the Workflow Channels that are assigned to the Data Cell's Account and/or UD member. Entity = Entity, Account=Volume, Origin=Import"Note I've use italics instead of using our entity names and workflow names.We didn't have this issue before so I'm not sure what has changed. The parent workflow profile stated in the validation message isn't actually the parent workflow profile so I'm totally confused. There is another post on this but I didn't understand the resolution. Could somebody please tell me what I would need to do to fix this? Thanks!

I am trying to determine if we are using any REST APIs. We were instructed to run a logonandreturncookie via Postman.https://documentation.onestream.com/1384528/Content/PDFs/REST_API_Implementation_Guide.pdf I followed the instructions in page 26 and ran into this error message: Error: Invalid character in header content ["Authorization"] I entered "{{webapi_access_token}}", similar to the screenshot in page 27. I hovered over the token and saw a message stating it's not defined.   Where should I set up this variable or is there an issue with my params/body?  

hello we're implementing people planning. due to data privacy concerns, we wanted restrict admins accessing the workflow. is it possible to trigger email as soon as workflow is accessed? 

Hi,not sure if anyone came across with this one but thought it was interesting to shareIf you have a file which has in the same line amount and annotation you can set View to YTD (or periodic), then in the text value complex expression use this api prop:api.Parser.TextValueRowViewMember = "Annotation"That will make the parser to automatically generate the line(s) with the annotation if text value have a value.HTH

Hi Everyone, I was recently working within a Demo Environment where I suddenly started getting error message when trying to access the import step in the Load and Transform (Import) step in the Import Workflow.  The Error above pops up every time anyone tries to access the Load and Transform (Import) step. Have anyone seen this issue before and knows how to fix it? NOTE: This issue is the same across all applications in this environment.  Thanks, Hamza 

Hi,is there a way how to apply composite rule on filled value only? If I use U8#* it takes every record filled or not.My intention is to use another rule behind this one to fill default value for blank source.