Workflow and Data Integration

I need to delete a single record in the Error Log but my Data Adapter won't let me, complaining about "unsafe SQL statements".In a rather bone-headed move, while developing a BR, I accidentally wrote an insanely large block of text to the Error Log -- like somewhere between 1.3 and 1.5 million characters -- in a single record via BRApi.ErrorLog.LogMessage.It's made the Error Log workspace page pretty much unusable because it's trying to read that record to display it. It takes 5 or 6 minutes to display the Error Log.After finding the UniqueID for the offending record in the ErrorLog table, I tried the following SQL in a Data Adapter to remove the record:DELETE TOP (1) from myOneStream_Framework.dbo.ErrorLog where UniqueID = 'bb5158a6-aae9-471c-b883-edddc8640a5e'Apparently, OneStream thinks I am a cyber-criminal and blocked my code execution with the following message: Database query error. The specified SQL statement is not safe.I also tried:UPDATE myOneStream_Framework.dbo.E

Hi, I am starting last month as Admin. I am trying to help one of our internal users with an issue. The amount that was imported by accounts and by base level LE_PC_CC that belongs to the gray area in this Workflow can't be seen or opened in this WF form to be manually adjusted. Is there something wrong with the configuration of the Workflow?  Thanks in advance!  

Hello everyone,We are trying to upload data to OS through a csv but I'm getting the following errorI checked the file both with excel and directly with a text editor and it seems the amount is correctly formattedDo you guys have any idea why OS is giving us this error?

Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners?  I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of.  Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status?Thanks in advance to anyone that can help! 

I need to add a Form Channel (Workspace) to our WF's for informational purposes.  Is there a way to exclude this from from the Dependent Status check of the WF for certification purposes.  The channel is defined as a workspace so we can embed a SQL grid report.  I already have similar channels where I have added buttons that control certification/decertification, this just requires the user to select the channel and then click the button.  Trying to get around forcing them to have to select when they might not need to view the provided data.   Understand I could move to a Dashboard but want to keep it in the WF and visible to users. 

Of all the File Share types, the one I least understand is the "Contents" folder.  What is it used for? There are even three System Security Roles controlling its use, but no clue in the Design and Reference guide as to what we are meant to use that folder for.  Can someone please educate me?  

I've seen an earlier post around this issue.  Was there a bug?  Is there a solution? thank you.

I have scheduled a data management sequence to run every 120 minutes between a specified time range (7 am to 9 am) -- But the data management sequence is not being executed. There are no parameters needed in the data management sequence, and I have confirmed that manually running the sequence works without error. When I check the grid view in Task Scheduler, I can see the "Next Start Date/Time" column is correct. However, when the system finally reaches that time, the task is not executed, the "Count" column remains as zero, and the "Next Start Date/Time" column updates to 120 minutes later. I receive no system errors on why the task is not executing.I have confirmed the scheduling a one time task, or even a daily task works successfully.  Any help on this would be great.

Is there any check that we can put in the WF confirmation step to check the if the data that was loaded through import was actually validated?I have configured the confirmation rules group which will show error/warning based on the threshold amount for the v_ Accounts.But if the data is not loaded to the cube, the variance accounts would still have zero balance, so the confirmations rules are still green as its technically within the threshold amount. Need to check if there is a way to not allow the users run the confirmation rules at all without passing the complete Import-Validate- Load sequence.

Hello there,I made an Event Handler capable of retrieving all 'Transformation' & 'Validation' rejects in order to treat these irregularities automatically. The script creates a 'List' type of transfo rule in the concerned dimensions and populates it with all the rejected source values. The script works just fine for most cases. However, if the group of transformation rules has One-To-One mappings then the 'List' rule is just ignored (since One-To-One is prioritized over Lists).My questions: - Since I cannot afford to go over original One-To-One mappings & change target value to 'ByPass', how can I modify the order of transformation rule types(List then O-t-O then composite etc...) ? If not possible, how can I retransform my data at the end of import using 'List' transfo rules only ? 

Hello, I'm trying to figure out a way to have OneStream perform profit in inventory eliminations.Currently we manually compile data in excel to calculate how much profit sitting in the inventory and at what common parent we need to eliminate it. These manual eliminations are ultimately loaded in OneStream via upload files.One thought is to setup custom input form in the workflows that would collect ins-&-outs of profit in the inventory and utilize Flow dimensionality. But I'm not sure if there is a better approach to this problem.  

Hi All, My team and I need to create a dashboard that will help the user in bulk certify workflow profiles. the whole interface is similar to Workflow Multi-Period Processing(screenshot) but with few changes, which will only focus on Certify the workflow profiles for import trial balance step for multiple LEs at once and not multiple steps for 1 LE. This needs to be created under Dashboard process. Is there any guide or marketplace solution for this? any help will be greatly appreciated.     

Is there a way to make a WF Step only show up quarterly?  We want to create a form for the BS Flux but it should be completed at Day 10 vs all of our other forms need to be completed on Day 7 so we were thinking to seperate the 2.  We would only want this step to show up for the quarters.  I know I can make the form only show up on the quarters but I dont want to have the users have to complete the Form, Process, Confirm steps on the off months.   Willing to hear any alternative ideas on how to do this.  We use Task Manager also so we want to know that the Day 7 forms are complete vs the BS Flux.   My other thought is to create a dashboard and attach it to the Task and have them complete it but they are so focused on the workflow that we would have to be constantly reminding them.

Hi Team,   I would like to know does anyone Implemented the OneStream Integration with NetSuite Cloud using RESTlets and I am looking for the right documentation and the details required from NetSuite cloud. Thanks  

Hi All,  Need assistance in posting a journal to eliminate the difference.  I tried posting a journal using reporting currency (ZAR) to eliminate the difference, but it's not going through. The translation should be periodic.    Anyone have any idea what I'm missing?  

Quick Question I have a WF with a Form Profile and the form has Jan - Dec with an account. 1. I Created WF Profile and assigned it too the WF Profile form 2. Made the account as No Data Lock.  3. Input the data and saved and locked the WF Profile Form. 4. When I navigate to Feb I still able to see input data for Jan and the Form is not locked? Any Idea what I am missing?

Originally posted by Stan AllanWe have a client that wants to develop and interface from Dynamics 365 F&O to provide the GL transaction data to OneStream. Is there an out of the box solution? Has this been done before? We have done D365 to ePBCS but it required an export to a data file from D365 that is a manual process. The client wants this process fully automated. Thanks 

Hey all,So we have built a data seedning between cubes for Predictive 1 2 3 and are using DataManagement data exports via Data mgmt export sequence to our input workflow profile.We have a hierarchy of maybe 100 member where we want to seed the parent member only (the total) excluding 5 accounts in oreder to make the transformation rules as friendly as possible. Are there any way in a member filter in the DM data export to exclude members from the hierarchy? I have tried .remove etc with no luck.Thanks in advance!

I am setting up a Workflow with a SQL connector data source. I need to be able select a range of periods (start and end period) within the SQL query to extract the balances for multiple periods and load the same to OS cube. Users should have a provision to select the start and end periods and the SQL query should run dynamically based on those periods. Workflow should be executed to import and load the data to the multi periods selected at one time (not needing to run one by one period).I am new to OS. Appreciate suggestions and recommendations to implement this requirement in OS.   

Reaching out to the community to see if someone has created a BR to trigger cube loads in a batch or sequence for several WF. Found this snippet but unsure how to use it: Dim objLoadCubeProcessInfo As LoadCubeProcessInfo = BRApi.Import.Process.LoadCube(si, wfClusterPk)

I am trying to connect to a OneStream Cloud environment for which the REST API has been enabled and tested by OneStream Support.I am working in PostMan and following the REST API guide at System Guides > REST API Implementation > REST API Overview > Authentication, but i am hitting an error "One or more required parameters are missing."I can retrieve the AzureAD token fine, but when I then try and use it to authenticate with OneStream (expecting the SI to use later on), I get the above error message returned (along with a HTTP/400 Bad Request).As far as I can see I am not missing any Parameters as per that section of the REST API Guide.The POST request is to:https://xxxx.onestreamcloud.com/onestreamapi/api/authentication/logon?api-version=7.2.0Params: api-version=7.20Authorization: Bearer Token returned from Azure AD (via a PostMan variable)Content-Type: application/jsonBody: BaseWebServerURL: https://xxxx.onestreamcloud.com/onestre

Hello,I have a REST API which has been tested in POSTMAN. The problem is data is being pushed into OneStream. So how would this work in the BR. Any help would be appreciated. Thank You,Indu

We have recently upgraded to version 6.5 from 5.1. Our Power BI consultants want to try the REST API to pull data out from OneStream repositories. Anyone has done this before and knows what setup/configuration need to perform before using REST API? Thanks

Hi all,We are successfully uploading budget information in an excel template. This is a matrix load containing 12 periods of data. For each line the user can upload a textvalue. This is also working. However, the comment is uploaded to each month. However, if there is no data for a particular month (which can happen) the comments are aggregated. For example: I have data in 2024M4 and 2024M12 for the budget. It is a periodic budget. Now I have the comment 4 times in 2024M4 and 8 times in 2024M12. Is there a way in a matrix excel upload to upload the textvalue only for the last period?What else could I do to overcome this issue?With kind regards,Tim

We have deleted certain transformation rule under 1:1 and while deleting, my other colleague was also updating the same transformation rule group.All those rule are showing up in the validate step as an error even though they are deleted.Error - > "Unmapped items" and then ask me to assign even though they don't exist. How can i get rid of them ?  ( have tried extracting trx , in the extract file, it doesn't show up)