Forum Discussion

Jasper_DPG's avatar
Jasper_DPG
New Contributor
2 months ago
Solved

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 ...
Time
  • JackLacava's avatar
    JackLacava
    2 months ago

    Have 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.

Jasper_DPG's avatar
Jasper_DPG
New Contributor
2 months ago

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.............. 11

Transformation 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? 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 months ago

Just set your header line to 0, i.e. like it wasn't there at all, then set the Static Value for each Time column to 2025M1, 2025M2 etc. The first line will be dropped anyway, when the system figures that it doesn't have numbers.

As for Time Outside Workflow View errors, you must have a mismatch between the year you've picked in OnePlace, and the data you're trying to load (and possibly your Scenario properties).