Time Dimension in Columns
Hello OneStream Community,
For our upcoming budget cycle, we want to create an inputsheet where the Time dimension is displayed in columns, with each month (January through December) as a separate ...
Forum Discussion
To add on this request, I have tried myself to create a data source as followed:
- data structure type: Matrix data
- created 12 source dimensions Time
- Data type: Matrix datakey text
- Every source dimension time is linked to the correct column
- Every source dimension time has a static value (2025M1 - 2025M12)
- Matrix header values line #: 1 (that's where the header is)
- Dimension 'amount' is set on column 0, I think it doesn't have a specific function in this case?
The error occurs during the import step, and the message is unhelpful, referencing Scenario/Time. I suspect this might be a generic error message for data import failures.
I'm confident I've missed a crucial step in the configuration. Could you please review my setup and point out what I might be missing?
JackLacava
OneStream Employee
OneStream EmployeeHave a look at the log file, by clicking on this icon
in the Import step. That file (open it with notepad) contains a description of error codes, and then specify one of those codes at the start of the line for each discarded line.
My typical oversight is to lack a valid Transformation Rule for Time - because it only accepts One-to-one, you have to enter in the rule all periods as they appear in headers.
I would also ensure Amount is mapped to a column that will always have a number - in most cases, the system still checks whether a row is valid by looking at what is found in the Amount location and ensuring it is a number, even if it's going to ignore it later.
This is already pretty helpfull, thank you.
I've tested some settings and when setting the Matrix Header Value Line # different changes the outcome.
#0: no lines were accepted (12 header rows have error code 4, all other lines 11)
#1: 12 lines are accepted (all not accepted lines have error code 11)
#2: 23 lines are accepted (1 header row is getting error code 4, rest has 11)
#3: 34 lines are accepted (2 header rows are getting error code 4, rest has 11)
#15: 166 lines are accepted (12 header rows are getting error code 4, rest has 11)
#100.000: 385 lines are accepted (35 rows are getting error code 4)When I change the amount cloumn in the last scenario from 0 to 8 (the 2025M1 column), the amount of accepted lines won't change, however the error codes do. Now there is 1 error code 4 and the rest is 11.
--------------- Log Codes ---------------
Non-Numeric Amount ..................... 4
Time Outside Workflow View.............. 11Transformation Rules shouldn't be a problem, because I'm uploading a file with OneStream time dimensions (2025M1, 2025M2 etc.). I have also added one-to-one transformation rules for all seperate months, but it didn't give another outcome.
Can't get my head around the issue, however maybe the test above gives you any clue on where the issue might be?