User Profile

SimonHesford

Contributor II

Joined 3 years ago

101 Posts64 LikesLikes received17 Solutions

View All Badges

User Widgets

Contributions

Re: Best Practice for Managing Outdated Members in Transformation Rules?
This is really a matter of preference or ease of maintenance. Leaving redundant account maps in the Transformation Rules has no material impact as data related to those accounts will not be imported ...
1 month ago Place Workflow and Data Integration
49Views
0likes
1Comment
Re: Best practice for filtering vStageSourceAndTargetDataWithAttributes by Workflow
How are you querying the data. Data Adapter using a SQL Query or Dashboard Dataset rule / service?
1 month ago Place Workflow and Data Integration
49Views
0likes
0Comments
Re: How to round the result of a calculation?
Your first example won't work because there is no Round function in OneStream. Your second example won't work because it is missing the Eval function
1 month ago Place Rules
50Views
0likes
0Comments
Re: Need to send data from OneStream to Snowflake using an existing SIC ODBC connection
If the credentials for the SIC Gateway have permission to insert, update, and/or delete records in a remote dataSource, a OneStream business rule could be leveraged to write-back, update, and/or dele...
1 month ago Place Workflow and Data Integration
73Views
1like
1Comment
Re: Central Import and Account Reconciliations
That is correct. I personally don't like the native central load functionality in OneStream for precisely this reason, as you lose ability to interrogate the imported data at the Workflow level. Wha...
1 month ago Place Workflow and Data Integration
100Views
1like
0Comments
Re: Europe SWIFT File
You will need to build out the parsing logic in a file based Connector if you want to do this in the OneStream application. Alternatively there are some .Net packages out there, paid & free, which h...
1 month ago Place Workflow and Data Integration
17Views
0likes
0Comments
Re: CAMT.053 Files (ISO20022)
The lack of responses probably gives you your answer 🙂You will have to build your own connector logic to parse the CAMT.053 file which is probably why you were told to stick with the BAI format as t...
1 month ago Place Workflow and Data Integration
109Views
1like
2Comments
Re: loading from ERP
Why are you splitting them into 10 seperate loads? Because of the data volumes in the imported datasets? What is the volume of records you are trying to import?
2 months ago Place Workflow and Data Integration
65Views
1like
0Comments
Re: Version v8 to v9 Upgrade
If you are moving to v9.2 you need to be aware that WinSCP use is fully deprecated i.e. the WinSCP assembly is no longer shipped as part of this version. Therefore if you have any SFTP functionality ...
3 months ago Place Application Build
228Views
1like
0Comments
Re: How to export from and import to custom OS tables
Table Data Manager will work no need to write a script (unless you want to)
4 months ago Place Workflow and Data Integration
203Views
0likes
0Comments

Groups

No places to display