Forum Discussion

fc's avatar
fc
Contributor
4 hours ago

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 used a Connector BR to retrieve data and normalize it before the datasource step.

I have never worked with delimited files loaded directly by clicking Import. It's not clear to me if I can still use a connector BR or if I need to use something else (a Parser BR?).

Can anyone help me understand what is the best practice in this case?

Thank you for the support!

Data Sources

1 Reply

  • JJones's avatar
    JJones
    Icon for OneStream Employee rankOneStream Employee
    59 minutes 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.