07-30-2021 10:28 AM - edited 08-24-2021 12:36 PM
Release Date: 12/08/2020 Updated
Prepared by: Peter Fugere
Summary: Do not create load partitions by period because it circumvents the default logic of the system to correctly do the math and present the correct data for different views.
Purpose: Understand the correct method to partition large data loads.
Key Facts and Recommendations:
Facts of a real-life situation
Create a load file by entity group. This is a much faster load because a subset of data can be loaded and because the data base grouped by entity there would be smaller partitions which allow the use of multithreading that’s built into OneStream software.
Benefits and Costs
Spreading sequential loads speeds up the data load and consolidation process, significantly improving performance improvement by using the built-in multithreading capability of the software.
Any deviations must be reviewed by the project team and signed off by the customer.