Switch - 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?3Views0likes0CommentsFiles 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("yan.savinsky@itochu.com,jin.yong@itochu.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 ClassMatrix 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.14Views0likes1CommentValidation Error: No security access to data cell being cleared
Hi Team, We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step: All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears. Strange thing is: they have uploaded data on this intersection before in previous Forecast Scenarios without errors Security has not changed for either the application, user, workflow profile, entity etc. these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence. Application Security: ModifyData is set to Everyone One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security. I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step. Anyone that can help me a little bit more in understanding the error or knows what could cause this? Thanks in advance!46Views0likes2CommentsCreate Table As Select
Hi, I need to build some tables in the application database. I am using a extensibility rule with a StringBuilder and the BRAPi.Database.ExecuteActionQuery command to do that. The "Create table" command is working fine. Eg: sqlScript.AppendLine("CREATE TABLE [PayrollMapping](") sqlScript.AppendLine("[Payroll] varchar(255),") sqlScript.AppendLine("[Pay_Basis] varchar(255),") sqlScript.AppendLine("[Salary_Annual_Factor] Int") sqlScript.AppendLine(") On [PRIMARY]") But I cannot make the "Create table as select" command work. Eg this does not work (Error: Incorrect syntax near the keyword 'Select') sqlScript.AppendLine("CREATE TABLE [EBSRegister] As") sqlScript.AppendLine("Select [RegisterID], [FirstName], [LastName]") sqlScript.AppendLine("From XFW_PLP_Register") Is the "Create table as select" not a valid command for the OneStream BRAPi.Database or is there simply something wrong with the syntax above? Thank youSolved7.4KViews0likes8CommentsEntity Dimension Maintenance via Workday Integration
Hi all! We're looking at creating an integration from Workday for automatic maintenance of our Entity dimension - including new member creation, hierarchy creation and movements, and text fields updates. Wondered if anyone else is doing something similar? Is it a complex integration, does it seem to work relatively seamlessly? Any best practices to share? Thanks in advance!25Views0likes3CommentsExcel Data Incorrectly Suppressing
I am trying to load stage data via Excel and having an issue I am not sure how to fix. I am loading data, including for attribute values 1 and 2 (AV1# and AV2#). However, if there is a zero in either AV1 or AV2 the row is suppressed, even if there is a non-zero value in the other attribute dimension. Is there a way around this behavior with a special token I can add or some other change?18Views0likes2CommentsAnyone doing planning at a proxy member?
Hi all, I'm just trying to get a feel for how common this use of proxy members is these days. I've worked for multiple organizations and typically, if we were planning at any level higher than the most granular level of data, we would plan a number representing a group of members, at some 'proxy' member created specifically for planning purposes. That is, we would not use some random existing base member that held actuals. For example: If our dimension hierarchy looks like the one below and we were planning at the Region Level: I would not plan for the entire RegionA by loading my planning data to "South3". Instead, I would create a unique member (say, "RegionA_Plan") and load my data there. Wondering how many companies out there would use the first method rather than the second method and what advantage there would be to this? Thanks in advance for your thoughts on this. RegionA North North1 North2 North3 South South1 South2 South3 East East1 East2 East3 WestSolved30Views0likes4Comments