Data Sources

149 Topics

OneStream - NetSuite
Looking for others experiencing issues getting a YTD dataset out of NetSuite for loading into OS. Also looking to connect with other users who use NetSuite for the ERP and OneStream for planning.
Ghalbrooks
3 years ago Place Workflow and Data Integration
9.6KViews
0likes
17Comments
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
Solved
RobbSalzmann
2 years ago Place Workflow and Data Integration
8.2KViews
2likes
23Comments
Data Imports
I have currently set up a new data source and associated transformation rules (and allocated to the appropriate workflow). Data importing is correctly working for 2022 time period, however I am getting the following error in any other time period...... I have got the Scenario as 'Current Datakey' and Time as matrix datakey in my columns Summary: No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. Any ideas? I am assuming this might be one simple setting change somewhere
JakeBrown
3 years ago Place Workflow and Data Integration
5.8KViews
0likes
11Comments
Importing data for multiple time periods
How can I import data for multiple time period all in one go? I was told that its possible. But wondering what settings do I need to change in order to do that. I tried using "Replace All Time" but the Time is set to "Current". I'm uploading a excel base file. Any guidance on this will be appreciated.
Solved
Mustafa_A
3 years ago Place Workflow and Data Integration
5.7KViews
0likes
8Comments
Direct Connect Loads into OneStream
When loading data into OneStream, our longest workflow takes ~40 minutes to load. We would like to try to kick off the 5 direct connect loads within this workflow to start simultaneously instead of sequentially. Have any of you organized your loads similarly and do you have tips or recommendations please?
Solved
Kelley_M
3 years ago Place Workflow and Data Integration
5KViews
0likes
8Comments
Execute Import > Validate > Process using a button on a dashboard
Hi I have a dashboard that executes an Import > Validate > Process using a business rule. In my workflow I am currently using Workspace, Import, Validate, Process, Confirm: I would like to just use Workspace, Confirm, but it gives me the following error: "Cannot execute step because the specified step classification doesn't exist for the workflow profile." Is there anyway around this? Thanks, Mark
Solved
MarkBird
2 years ago Place Workflow and Data Integration
4.8KViews
0likes
14Comments
Data load for specific time period pulling data from other time periods
Hi all, I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up. However some of the data is being loaded into months it shouldn't be, even though on the in the csv file the data is pointing to the correct time period. So for example in the upload file, data is put against time periods such as 2023M1, 2023M2 etc. Having imported the data, validated it and loaded it to the reporting cube we have, some of the data is being loaded into 2023M1 and also 2023M2, when on the upload file it's only on there once against 2023M1. I've checked the transformation rules and everything is set up correctly in terms of translating the import file, so I was wondering if anyone has come across this type of issue before or if anyone has any advice as to where I could look next? I'm pretty new to OneStream so any help would be much appreciated. Thanks, Ged
GedS1
3 years ago Place Workflow and Data Integration
4.2KViews
0likes
5Comments
Fields reference in a Connector Datasrc
Hi all, I need to assign a value in a field, dependeing on an other. I can do it in Delimited Files using "api.Parser.DelimitedParsedValues()" but I don't know wich function can provide me the string of an other field. So, in conclusion: how can I do this in a Connector Complex expression? Thanks!
Solved
aprats
3 years ago Place Workflow and Data Integration
4.2KViews
0likes
6Comments
Actuals data load issue - YTD adjustment being loaded
Hi all, I have an issue whereby I'm loading our company actuals into OneStream, but if a General Ledger code has no data in it but had data in previous months, I think OneStream assumes the YTD value to be zero and so the opposite total of the previous months is being loaded. So for example the YTD total of repairs & maintenance may be £100 at Apr-22, and in May-22 there are no further transactions so the YTD position is still £100. However as no transactions occurred in May, when the data is loaded -£100 appears in May. I've checked the DateSource and TransformationRules we have set up, I cant see a reason why this would be happening as it's all set up as 'Periodic', and so only the data from the initial load should be include. Does anyone have any ideas as to where the problem my lie, or where I could look to try and see why this is happening? Many thanks, Ged
Solved
GedS1
3 years ago Place Workflow and Data Integration
4.1KViews
0likes
4Comments
Data Load showing negative number
Hi All - I'm trying to understand why this would occur. I had loaded some prior year data, but somehow one of the month is showing negative numbers. I tried to consolidate but it wouldn't change. Wondering what I need to do to fix this?
Mustafa_A
3 years ago Place Workflow and Data Integration
3.9KViews
0likes
6Comments