The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

jeffvdt's avatar
jeffvdt
New Contributor III
3 months 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?

Data Integration
Data Management
Data Sources
Transformation
Workflow

2 Replies

  • JohnHenry's avatar
    JohnHenry
    New Contributor III
    2 months 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.