SimonHesfordContributor IIJoined 3 years ago101 Posts64 LikesLikes received17 SolutionsView All Badges
ContributionsMost RecentMost LikesSolutionsRe: 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 ...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? 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 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...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...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...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...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? 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 ...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)