Forum Discussion

Jasper_DPG's avatar
Jasper_DPG
New Contributor
7 days 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 column.

Our current data sources are configured with the time dimension in rows, and I'm struggling to set up the data source to handle a matrix layout. I've tried using data transformations and source dimensions, but I haven't been able to make it work.

Has anyone dealt with a similar scenario and can provide a clear method for configuring the data source and mappings correctly?

Any guidance would be greatly appreciated!

Thank you, 
Jasper

Time
  • JackLacava's avatar
    JackLacava
    6 days 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.

5 Replies

  • Jasper_DPG's avatar
    Jasper_DPG
    New Contributor
    7 days ago

    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's avatar
      JackLacava
      Honored Contributor
      6 days 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
        6 days 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? 

  • sameburn's avatar
    sameburn
    Contributor III
    7 days ago

    Hi Jasper_DPG​ 

    That Scenario/Time error means that your Data Source is not reading any data.

    Have you had a look at the examples in GolfStream?  There are examples there of Matrix Data Source(s)

    Sam