Join Framework table data to Application table data using SQL
SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user data are all just the unique identifiers, and not actual user names. Currently I only know of user names being kept in the Framework database location, in the SecUser table (or similar ones). Is there specific syntax I can use that will allow me to read from that database location (Framework) while running an SQL query capturing the rest of my data in the application database location through a dashboard data adapter? Or does this need to be done using a business rule to combine two tables? Thanks.
Unable to get value from another column in Parser BR
OneStream V7.0.1 We have a Data Source that takes data file that has 12 data columns Oct ... Sep. The year for the data in the 12 data columns is a field "Fiscal Year", the first column of the data file. We have a Parser BR that is called on each of the 12 data columns that looks at the first field in each record to get the year and concatenates that with the M<number> month for each month column to give the correct Time dimension member in which to store the data. e.g. 2023M1 The problem is we're getting the row header "Fiscal Year" instead of the year value in the record, so the string being returned looks like Fiscal YearM1 How do we get the year data from the first column instead of the column header? Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As ParserDimension, ByVal args As ParserArgs) As Object Dim fiscalYear As String() = {"Oct","Nov","Dec""Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"} Dim YearColPosition As Integer = 0 Dim year As String = String.Empty Dim month As String = String.Empty Try 'Both of these keep giving us the column header "Fiscal Year" 'instead Of the value In the currently parsed record year = api.Parser.DelimitedParsedValues(YearColPosition) 'year = args.Line.Split(",")(YearColPosition) 'this marries the index of the month name in the months array 'with M to give us the M1 notation for period. month = $"M{Array.IndexOf(fiscalYear, args.Value)+1}" BRApi.ErrorLog.LogMessage(si, $"Time: {year}{month}") Return $"{year}{month}" Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function
Can PowerBI be connected to OneStream to pull CV Excel reports that are saved in File Explorer?
We are currently producing and saving excel extracts of CV's into File Explorer using books/parcel service. We would like to connect PowerBI to OneStream to pick up these files from the OS managed server. Is this possible?
Derivative rules
Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances. I thought this would be easy enough with a derivative rule; first create an interim rule to aggregate the accounts and then create a final rule to check if the balance is greater / less than 0. Finally, I have used the final derivative rule in my target account mapping. But, this is not quite working as expected. It seems to just add the negative balances of the individual GL accounts under the "_N" rule and the positive balances under "_P" rule, therefore both my expense and revenue account in OS ends with a balance. Could you please suggest what I am doing wrong? Regards, S
