Forum Discussion

fc's avatar
fc
Contributor
20 days ago
Solved

Delimited file Import and normalization

Hi everyone,  I need to set up a few transformations to normalize a delimited file that will be uploaded by the users, before feeding it to the datasource. I previously worked with FTP folders, and...
Data Sources
  • MarcusH's avatar
    MarcusH
    17 days ago

    You can use a matrix format data source and add multiple Account columns (search for Matrix Data Load for more info). The Golfstream app has a few examples (HoustonBudget). Alternatively you can use the TransformationEventHandler Business Rule to intercept the selected file and restructure it. I would go with the matrix format.

JJones's avatar
JJones
Icon for OneStream Employee rankOneStream Employee
20 days ago

You would first need to create a Delimited Data Source that defines what column in your source CSV file maps to each dimension within your OneStream Cube.  If you need to parse the file, you will use Parser rules to parse the data in the file as necessary.

There are some examples you can find in the Design and Reference Guide available on OneStream Documentation that may help you with this.