Workflow and Data Integration

Hi there,I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef

Hi all we have this error with our SIC connection to SAPhe SSL connection could not be established, see inner exception.)The SSL connection could not be established, see inner exception.Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..An existing connection was forcibly closed by the remote host. (Socket Error Number 10054)Anyone seen this before and knows how we can resolve?Nouria

Hi All,Could you please provide the code for sending a CSV file from OneStream to the SAP environment using the PUT API?Thanks,Chandrakala  

I'm trying to load a workflow using an Excel template and need to set the *WorkflowName* as one of the following: Import, Validate, Load, Process, Workspace, Confirm.Currently, I'm using the highlighted value in the *Workflow* column for this purpose.Similarly, if I need to set the *WorkflowName* to Workspace, Direct, Process, Confirm, Certify using the template, what value should I use? Is there a reference list for this, or where can I find it?   

Hello All,Is it possible to establish a connection between SAP SuccessFactors and Onestream?Thanks,Chandu  

Hi All,We currently have BiBlend set up to use all 20 attributes. We're considering reusing two attributes to load data from different columns (these attributes are currently used but are no longer needed). Our plan involves renaming these attributes in the Cube Settings and updating the data source.Does anyone know if this is possible? Are there any restrictions or limitations on how attributes can be used or modified after the initial configuration?Thanks in advance for your insights.

Hi Everyone. I have a question about how I can assign the entity that appears in my Calculation Definitions to my assigned Data Management Step. Currently, I have it set to E#Root.WFProfileEntities, but since I have it in a Profile that does not have entities assigned (because it is a Profile where I want to mark all my WF as complete), it gives me an error when I try to use it from there.  

Hi all,  I'm after some guidance for a capex form that I'm currently developing. Simply, it's a form that takes the current month closing balance (BS accounts) less the prior month closing balance, and need to categorise these movements.  At the end of FY24, 2 entities liquidated (LQE) and transferred assets to a new entity. In the entity dimension, it's timestamped in the 2 entities as no longer in use from FY25 M1 onwards. So for FY25, there is no form to fill in for the 2 LQE's but there is for the new entity. However, at group level, it shows the FY24 balance with 2 LQE's and no balance for new entity, and FY25 is no LQE's, just the new entity. Because the setting means the 2 entities are no longer part of the group, it's no longer showing in the movement columns. See below.  The real movement for the month to be explained is -33k, but the calculated movement ignores the 2 LQE's and just shows the new entity with +164k addition. Any ideas how I can develop this form

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) through batch?

Hello OneStream Community,I'm working on how to implement a REST API in OS, but i'm not sure to understand all the steps, i've already read the documentation and i've found it very hard to understand, can anyone please explain how can we implement it in OS what are the steps to follow, i started by downloading and installing POSTMAN for the tests but i don't know what should do i do after, please any help will be much appreciated. I'm also woundering if there any data management that should be used for this Thanks and merry christmas.

I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension.ACCT600 DEPT101  --> ACT_EXP600_100ACTT600 DEPT321  --> ACT_EXP600_100Where departments 101 and 321 are descendants of Dept_TotRD

Hello,Has anyone seen this before where the task scheduler looks as if it will skip a date? Under the grid view, the autoloads highlighted are skipping 10/1/24 even though they are all set to run the first and the second day of every month. Weirdly enough, under the calendar view, they are listed correctly under 10/1 date column and after a few switches back and forth it reset itself back to 10/1 without any other action. Any idea would be appreciated. 

I have come across a validation error that is kind of vague. I created a new entity, confirmed it is setup the same way as its sibling, and added it to my transformation rules, but my validation step kicks out an error. Any ideas?  

Hi Everyone. I had a Business Rule that checked the Workflow table to see if a scenario was blocked, but it always showed WFProfiles as blocked. I don’t know where this information is coming from, as those WFProfiles were unblocked in the environment but appeared as blocked in the table. How can I verify this information?  

Hi,I have designed a dashboard using SQL adapter and have stitched multiple OS tables.Current ask is to integrate this dashboard data and sent it out to an external db.I can create a table in the external db reflecting the same column structure.What is an efficient way to integrate this data from OS dashboard to external db-FYI- I have SIC in place.Thanks for your time

Hi,I’m currently working on a project where I need to omit a derivative rule, but only for a specific period. I'm looking for the most effective and clean way to achieve this without disrupting other rules or calculations that remain in effect.Does anyone have experience with this or suggestions on how best to approach it? I’d appreciate insights on both technical implementation and best practices to ensure future maintainability.Thank you, 

Hi, How do you certify multiple entities for a specific month? Do you need to go into each subsidiary’s local workflow to certify, or is there a convenient shortcut for this? We have several companies in our group that we sometimes need to uncertify and then certify again.I have tried going through the main act to process certification for the companies, but it doesn’t seem to work when you check the various subsidiaries’ local workflows.    

Hey everyone, My first post, so I hope I'm in the right place. While trying to upload an Excel JE Temp to a WF, the following error appears. I can confirm that the entity member filter is consistent for both the OS Temp and the excel Temp. Also, the same Temp has been used to load data in one of the previous months, with no error. Any suggestions/help would be appreciated.  -Amrit G. 

I have created a workflow profile, and the data source for the workflow is a CSV file with several columns. In this file, the second column contains account numbers. I specified the 'Text Fill Settings -> Lead Fill Value' as 'A' in the data source as I need to append with A Infront of the account. Additionally, I have defined a transformation rule. However, when I execute the workflow, I get the following error message: 'Validation Messages: Invalid member name. Account: 652901.'"  Could you please suggest, is there anything that I am missing?

Trying to create a Data Source.  I have multiple spreadsheets of the same format with the account name I need to load to in cell B1.  Each .csv file is for a different account that is specified in B1.  How can I make all subsequent rows use the account is in that one cell B1 on each spreadsheet?

 we have a query where we have a list of Tasks that are running one after the other but are not linked, and if one of them fails for whatever reason, the rest of the tasks also stop running. We have been informed by OS that this is not possible to configure this behaviour within the specific task or Data management so we can control which tasks stop and which ones need to be completed in case one of them fails. We believe this makes sense to have a parameter / setting to set against each individual tasks if they just stop running or continue to completion in case of of the other tasks fail. At the moment they all fail when there is an error.  

I'm unable to import from SAP, i have an error message Summary: Unable to execute Business Rule 'SAP_TB_ALL'. Cannot call classic RFC API. See help for details.Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).See SAP note 413708. Please make sure you have installed Visual C++ 2005 SP1 ATL Security Update (x64). Unable to load DLL 'librfc32.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) how to fix this issue?  

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6).  I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead. In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6. Is there a way to suppress zero after the script runs or write zero suppress into the script?  Thanks Scott

 Hi All,I'm encountering an error while trying to import data:"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."I've attempted both options for the time dimension—applying 'Datakey Text' and then assigning the Time field, as well as using the 'current Data key time' options—but it’s still not working.For reference, I've attached the relevant code:```csharpvar fields = new List<string>{"ACCOUNT","ACTUAL","Time"};return fields;string wfYear = TimeDimHelper.GetYearFromId(api.WorkflowUnitPk.TimeKey).ToString();int wfMonth = TimeDimHelper.GetSubComponentsFromId(api.WorkflowUnitPk.TimeKey).Month;string periodName = $"{wfYear}M{wfMonth}";var sql = new StringBuilder();sql.Append("SELECT ");sql.Append("ACCOUNT, ");sql.Append("ACTUAL, ");sql.Append("Time ");sql.Append("FROM [tablename] ");sql.Append

I cloned an existing connection that pulls the Scenario and Date from the workflow.  The new connection is requiring me setup a  New Scenario Transformation rule that is basically Budget --> Budget and time rule 2024M1 --> 2024M1.  The connection I cloned doesn't require the additional rules and was pulling Actuals.  All my Data Sources, Scenario, and Workflow settings seem the same.  Any suggestions on what I am missing?  I don't want to maintain the time rules, so that's why I'm trying to see what I'm doing wrong.