Skip to main content
uvrao33
Newcomer
Nov 11, 2025 1:41 PM UTC
Solved

Time/data setting in data source/Transformation rule for Multiperiod upload (delimited files)

Hi Everyone,

I'm trying to build Data source and transformation rule for multi period manual data load through single file. The import step didn't succussed.
Can anyone suggest time settings in data source & transformation rule. I selected data type as "Stored Data key text" in Data source .
My source file format is  Col1 has GL accounts, Col2-13 Jan to Dec data.

 

LinaUAnswer
Member
Nov 12, 2025 4:55 PM UTC

Hi uvrao33,

When you select the Data Source at the top, look at the Properties section on the bottom half of the page, just below the data source image. That’s where you’ll find the Data Structure Type field set to Matrix Data:

 

View in thread

5 replies

KH1
KH1
Contributor
Nov 11, 2025 6:18 PM UTC

You may find practical advice from some of the "Matrix" posts as linked. GL.
Matrix - Search | OneStream Community

LinaU
Member
Nov 12, 2025 3:39 AM UTC

Hello,

You should set the Data Source Property – Data Structure Type to Matrix Data instead of Tabular Data. Then, create eleven additional Time Source Dimensions, set their Data Type to Matrix DataKey Text, and map them to your columns, like this:

 

    uvrao33Author
    Newcomer
    Nov 12, 2025 2:32 PM UTC

    Hi LinaU,

    I don't see Matrix data option for Data Type, I've options Data Key text, Stored Datakey text, Global Datakey time and Current datakey time. Please advise where can I get Matrix data.

    LinaUAnswer
    Member
    Nov 12, 2025 4:55 PM UTC

    Hi uvrao33,

    When you select the Data Source at the top, look at the Properties section on the bottom half of the page, just below the data source image. That’s where you’ll find the Data Structure Type field set to Matrix Data:

     

      Terms & ConditionsAccessibility statement