Automating Data Access from OneStream to Snowflake: Exporting Financial and Master Data
How to configure the OneStream system to push the transaction and master data (dimensions) to Snowflake without manual intervention? I need step-by-step Info how to pull data from Snowflake into OneStream.361Views0likes4CommentsOneStream and D365 Integration
Hi everyone, I'm currently working on integrating OneStream with Dynamics 365 (D365) and would love to hear about your experiences. Specifically, I'm interested in knowing which connector you used for the integration. Did you opt for OData, Synapse Link, or another method? Any insights, tips, or recommendations would be greatly appreciated! Thanks in advance!Matrix Data Load Basics
I have a matrix data load question. I get the concept of how the matrix data load works. I haven't done too many of them, so I want to make sure I'm not missing the basics. The file I have has the year on one of the first lines in column 9. The next row contains the headers with periods in 12 separate columns. Is there an easy way to get the year from the first line (without a lot of code)? Or should I get year based on the POV? Then I am guessing a complex expression in the time columns to build the OS time key? I know I can do all of this in code, but I don't want to skip over any out of the box functionality or best practices. Any good guides on some of the best approaches with the Matrix load? Thanks, ScottSolved995Views0likes4CommentsExternal Connection for OS App in Same Environment?
Hi there everyone, Anyone ever created a connection between apps in the same OS environment? Working on some data movement and I have the connector set up, but struggling a bit with the connection string for the external database connection I'm setting up to reference the app I'm pulling data from. Is it the same syntax as the BI Blend connection, or are there other keywords that need to be in there? Thanks!Scheduling an extract of metadata
I'm being asked to schedule an extract of the OneStream metadata. I'm under the impression that this cannot be done using the Task Scheduler since an extract of metadata is not an option in Data Management. Is this an accurate statement? If this can be schedule, how so? Thanks!Solved2KViews0likes7CommentsFiles manipulation on SFTP Location
I need to move some files around the various folders on our SFTP server and I am trying to do it via the Extender BR. Basically I need to move the files from the staging folder into various other folders based on the file names. The rule below compiles successfully. When executed, I get the exception on the second pass ("Chase" related) but no files are being moved anywhere. I am stumped at the moment and would appreciate any suggestions. Thank you in advance. Yan Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try 'Set up SFTP connection session options Dim sessionOptions As New sessionOptions With sessionOptions .Protocol = Protocol.Sftp .HostName = "xxxxxxxxxx.xxxxx.com" .UserName = "XXXXXXX" .Password = "xxxXXxxxXXXXXx" .SshHostKeyFingerprint = "ssh-rsaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxpNuL5H42WiDJY=" End With 'Use Session Using session As New Session 'Connect session.Open(sessionOptions) Dim transferOptions As New TransferOptions transferOptions.TransferMode = TransferMode.Binary Dim baiDirLocation As String = session.HomePath & "/test/TXM/BAI/" Dim remoteFiles As RemoteDirectoryInfo = session.ListDirectory(baiDirLocation) Dim results As TransferOperationResult Dim fileNumber As Integer = 0 For Each x As RemoteFileInfo In remoteFiles.Files Dim newName As String = Nothing If x.Name.Contains("Mizuho") Then results = session.PutFiles(baiDirLocation & x.Name, baiDirLocation & "Mizuho/" & x.Name, False, TransferOptions) If Not results.IsSuccess Then Throw New Exception("The file transfer from SFTP to OneStream harvest failed 1.") End If ElseIf x.Name.Contains("Chase") Then results = session.PutFiles(baiDirLocation & x.Name, baiDirLocation & "Chase/" & x.Name, False, TransferOptions) If Not results.IsSuccess Then Throw New Exception("The file transfer from SFTP to OneStream harvest failed 2.") End If 'Nothing End If 'Move or Remove Files or Move SFTP files to archive 'Session.RemoveFiles(glDirLocation & "S4iiisubdata_US50.txt") fileNumber += 1 Next 'Next Ends the Loop End Using 'Setup email distribution list When files are present Dim distributionList As New List(Of String) distributionList.Add("yyy.yyyyyyy@yyyyy.com,xxx.xxxxxxx@xxxxx.com") 'Calls email Sub Routine 'EmailNotification(batchinfo, si, distributionList) Return Nothing Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function End ClassSolved37Views0likes4CommentsSwitch - sign to first position in SAP connector
The query from SAP is currently returning the negative sign in the last position of a cell. ex. 20.56- when it should be -20.56 Is there an SAP function I can add to the SAP connector solution that would place the - in the first position and how would I achieve this in OneStream?45Views0likes0CommentsMatrix Data Load
We are looking to load data from a year-to-date (YTD) consolidated statement of subsidiaries. The statement is in matrix form, with accounts (both balance sheet and profit & loss) in rows and companies in columns. Each company has two sets of columns: one for financial results and one for eliminations. How can we set up the data source to read multiple companies' statements from one file? We would like to load eliminations to a separate origin (Elimination). How can we change the destination for the Elimination columns? Also, how do we set up bypass row so that the load ignores headers and total rows? I noticed those rows can be identified by the Account column, where if the account is blank, then bypass.Solved