Forum Discussion

jeffvdt's avatar
jeffvdt
New Contributor III
21 days ago

loading sub-ledger data into OneStream

Hi Community :)

We are currently in development with regard to loading sub-ledger data into OneStream, but the balance specifications are so granular that we currently have them split into about 10 distinct loads. Because of this setup, our end users are being forced to manually click "Load and Transform" 10+ times to get a complete sub-ledger balance loaded for the period.

Obviously, this is tedious, creates a poor user experience, and introduces a lot of room for human error. We want to streamline this. What is best practice to do this?

2 Replies

  • JohnHenry's avatar
    JohnHenry
    New Contributor III
    18 days ago

    Are you loading into the Stage table.  If yes, the either create a single large file and load, or break it down into multiple files and automate the load/transform process through a data management sequence.  I['ve seen where all files can be automated to load nightly, even GL Journal Detail files with 1.5million records in a single zip file.